Skip to main content
Solved

Fields PARAM_NAME and COLUMN_NAME_TO_SET on business rules param and column tables


Bretas
Do Gooder (Employee)
Forum|alt.badge.img+1
  • Do Gooder (Employee)
  • 1 reply

Is it possible to extract the values from the PARAM_NAME column in the PROCESS_PARAM_PERFORM_VAL table? The FSM information log references this table, but I’m unable to extract it using Import/Export or the SQL Query Tool.

The same happens with the COLUMN_NAME_TO_SET field in the PROCESS_PARAM_COLUMN_VAL table. Can anyone help me with this information?

Best answer by Morris

Hi ​@Bretas 

I think one aspect of your issue is that the field Param_Name on the Process_param_perform_val table is not in the database, its Non DB.

 

you can try using this sql as an example to see the param_name

 

SELECT 
    metrix_perform_param.element_name AS param_name,
    process_param_perform_val.*,
    metrix_perform_param.*
FROM 
    process_param_perform_val WITH (NOLOCK)
LEFT JOIN 
    metrix_process_param_def WITH (NOLOCK)
    ON process_param_perform_val.process_id = metrix_process_param_def.process_id
    AND process_param_perform_val.param_sequence = metrix_process_param_def.param_sequence
LEFT JOIN 
    metrix_perform_param WITH (NOLOCK)
    ON metrix_perform_param.sequence = process_param_perform_val.perform_param_seq
    AND metrix_perform_param.perform_name = metrix_process_param_def.perform_name_to_call
   AND metrix_perform_param.element_name  is not null
WHERE 
    process_param_perform_val.process_id = '03'

 

Hope this helps,

 

Morris

View original
Did this topic help you find an answer to your question?

3 replies

Shneor Cheshin
Superhero (Employee)
Forum|alt.badge.img+28
  • Superhero (Employee)
  • 1168 replies
  • June 16, 2025

Hi ​@Bretas 

What is the param_name? Can you provide a screenshot of what you are trying to fetch?

About the ‘Column Name to Set’

SELECT 
COLUMN_NAME_TO_SET, 
TABLE_NAME_TO_SET,
PROCESS_ID
FROM
CUST_PROCESS_PARAM_DEF

Cheers!


Forum|alt.badge.img+10
  • Hero (Employee)
  • 102 replies
  • Answer
  • June 17, 2025

Hi ​@Bretas 

I think one aspect of your issue is that the field Param_Name on the Process_param_perform_val table is not in the database, its Non DB.

 

you can try using this sql as an example to see the param_name

 

SELECT 
    metrix_perform_param.element_name AS param_name,
    process_param_perform_val.*,
    metrix_perform_param.*
FROM 
    process_param_perform_val WITH (NOLOCK)
LEFT JOIN 
    metrix_process_param_def WITH (NOLOCK)
    ON process_param_perform_val.process_id = metrix_process_param_def.process_id
    AND process_param_perform_val.param_sequence = metrix_process_param_def.param_sequence
LEFT JOIN 
    metrix_perform_param WITH (NOLOCK)
    ON metrix_perform_param.sequence = process_param_perform_val.perform_param_seq
    AND metrix_perform_param.perform_name = metrix_process_param_def.perform_name_to_call
   AND metrix_perform_param.element_name  is not null
WHERE 
    process_param_perform_val.process_id = '03'

 

Hope this helps,

 

Morris


Bretas
Do Gooder (Employee)
Forum|alt.badge.img+1
  • Author
  • Do Gooder (Employee)
  • 1 reply
  • June 18, 2025

Thanks! This query will help me automate the documentation related to business rules.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings