My thoughts
-> Since you said it didn't show data when you click Try it -> then do you have data in your tables (RITMs have approval records and those RITMs have SC Task with them)
-> It all depends whether you want to join sc_task or not => based on customer requirement
I shared solution already for this couple of years ago and it worked fine
-> Try to re-order the View tables as per below
Help With Database View (RITM-Approvals/SCTASK-Assignment Groups)
If my response helped please mark it correct and close the thread so that it benefits future readers.
Can you keep order for sc_req_item to 100 and update sysapproval_approver order to 200 and try again.
Also use underscore '_' for where clause rather than dot '.', refer below for sample
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
Yes, since approver is common field across the tables you should be able to make it work. Make sure to define the order sequentially and where clause correctly.
Below is a sample configuration for 3 tables in database view
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
Hi @Bhuvan ,
below i am trying to add the approver column for the catalog task as well along with the ritm records for this i have created below queries
above is the condition i am using it for joining 3 tables
here but when i try to run it i am not getting any data for the report
as shown below
am i missing something here ?
do help !!
thankss
