When we apply filter below for particular process not working on pending transactions report
we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resignation process so we apply condtion(txnh.module_identifier ='Resignation') but its not working again alos coming all above process names.
Could you please assist on this.
Thanks in adavance
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT txnh.module_identifier ProcessName,
CAST(wft.assignees as VARCHAR(9)) CurrentAssignee,