Clarity

  • 1.  List of processes that contain a specific text

    Posted Aug 23, 2012 04:29 PM
    Hi,

    How do I get a list of all the processes / process scripts which contain a specific text (for example 'ORAP99')
    I am not sure how to do it. Is there an existing query to get this data?

    Thanks!


  • 2.  RE: List of processes that contain a specific text
    Best Answer

    Posted Aug 23, 2012 05:55 PM
    Trying to find hard coded schema names by chance?

    For GEL scripts you'll primarily want to be looking here:
    select script_text from cmn_custom_scripts;

    In case it's been put into a process script's parameters, that could be here:
    select param_value from cmn_custom_script_params;

    If you're unlucky to have used such terms in your pre/post conditions somehow, check here:
    select expression from odf_filter_expressions;

    And one other likely place to find this term if it is a schema name, will be in NSQL queries, which you can check here:
    select nsql_text from cmn_nsql_queries;

    Hope that was what you were after. If you need to stitch together the cmn_custom_scripts (gel scripts) back to a process design, it would go something like this (but I won't get to double-check this until the morning so consider this an attempt on the fly):

    select p.process_code, step.step_code, action.action_code, script.script_text
    from bpm_def_processes p
    join bpm_def_process_versions pv on p.id = pv.process_id
    join bpm_def_stages stage on stage.process_version_id = pv.id
    join bpm_def_steps step on step.stage_id = stage.id
    join bpm_def_step_actions action on action.step_id = step.id
    join cmn_custom_scripts script on script.id = action.script_id
    /* where ... add your filters here to find what you're after */


  • 3.  RE: List of processes that contain a specific text

    Posted Aug 25, 2012 12:48 PM
    Thanks for your prompt reply, Nick_darlington!
    Yes, I was trying to find schema name and this is exactly what I was looking for!!

    Thanks jpereza...the issue is resolved!


  • 4.  RE: List of processes that contain a specific text

    Posted Aug 25, 2012 01:56 AM
    All depends .... Specific text where (process name? id? subject action item? description?) ...

    If you want to find specific text in description you should use

    select ai_description from BPM_DEF_STEP_ACTIONS where ai_description like '%specific text%'

    select DESCRIPTION from CAL_ACTION_ITEMS

    where DESCRIPTION like '%specific text%'