Hi All,
we have one requirement,
We need a table view created that combines playbook_checklist_task and the work_request tables (outer join on the First Reported By field) so that we can see work requests created from tasks in a list of tasks. It will need to include all rows from the Task table and any Work Request rows that match a Task ID in the First Reported By field.
1. The First Reported By field present on the Work Request table it is reference field and refers to the playbook_checklist_task table.
2. Task ID i.e task number.
could you please help me to achieve the above requirement.
Thank you
checklist task table
work request table
Hi @Sonu Parab ,
Can you check if there is any common field on both the tables.
For Example : If we consider RITM and SCTASK table, we can do like this . Similarly you can try with the tables mentioned above if you find that one field.
Please mark my answer correct/helpful if it solves your query.
Thanks,
