When we apply filter below for particular process not working on pending transactions report

Summary:

Hi Team,

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

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SELECT A.* 

FROM

(

SELECT txnh.module_identifier ProcessName,

 wft.creator Requestor,

 CAST(wft.assignees as VARCHAR(9)) CurrentAssignee,

 wft.assigneesdisplayname CurrentAssigneename,

 wft.assigneddate AssignedDate,