In ii_app schema, you can use mutliple standard Functions that will gives you elements from Report data :
Each time, replace p_context_input by your context input.
-
ii_app.f_ii_core_extract_context_value_from_context(p_context_input , p_context_key) > replace p_parameter_name by ‘NAME_OF_PARAM’, the function will return its value casted in text.
-
ii_app.f_ii_core_extract_parameter_value_from_context(p_context_input , p_parameter_name) > replace p_parameter_name by ‘userUsername’, the function will return its value casted in text.
-
ii_app.f_ii_core_extract_multi_select_from_row(p_context_input , p_context_column ) > replace p_context_column by ‘fk_status_id’, the function will return its value casted in text.
-
ii_app.f_ii_core_extract_column_value_from_old_row(p_context_input , p_context_column ) > replace p_context_column by ‘fk_status_id’, the function will return its value casted in text.
-
ii_app.f_ii_core_extract_multi_select_from_row(p_context_input , p_context_column ) > replace p_context_column by ‘fk_multi_status_id’, the function will return a record containing all values in casted in text.
-
ii_app.f_ii_core_extract_json_element_from_context(p_context_input , p_json_element) > replace p_json_element by ‘row’, the function will return a jsoncontaining all values in casted in text.