Workflow name from sys_variable_value

Sharique Azim
Kilo Sage

Hi All,

I am trying to find the name of the workflow where this scripts have used some keywords.

Im referring to Searching the script field(s) of workflow activities   this post to give you a fair idea what im looking for.

1 ACCEPTED SOLUTION

kristenankeny
Tera Guru

You'll have to look up the record housed in the document_key - this points to wf_activity table and this table has a field called workflow_version which will tell you which workflow is using that activity. That record has a field called "name" if you need the name of the workflow and not the sys_id.


View solution in original post

3 REPLIES 3

kristenankeny
Tera Guru

You'll have to look up the record housed in the document_key - this points to wf_activity table and this table has a field called workflow_version which will tell you which workflow is using that activity. That record has a field called "name" if you need the name of the workflow and not the sys_id.


Thank you Kristen, your direction was helpful.


Although for definite results i had to glideQuery .


Hi,

Could you please provide the exact script which you have used?

Thanks,

RR