Creating a report of parent records with associated tasks - (No Sound)
ฝัง
- เผยแพร่เมื่อ 14 พ.ค. 2024
- At some point or another as a #servicenowadmin you will be asked to produce a report showing parent records with associated tasks.
For Example: Your organization has active request items with no tasks being generated by the workflow or flow design and you have been asked to get a list.
Solution:
▪️ Create a report using sc_req_item with the condition Active is True.
▪️ Below the condition builder execute "Related list conditions".
▪️ Select "Catalog task - Parent".
▪️ Directly above you'll see a quantity link which defaults to "Greater than or Equal to 1"
▪️ Change this to "Equal to 0" and run.
Obviously this isn't just limited to catalog tasks, it can be leveraged on any table with a related list. - เพลง