Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
When we apply filter below for particular process not working on pending transactions report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
21
Views
2
Comments

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!