Скачать с ютуб Creating a report of parent records with associated tasks - (No Sound) в хорошем качестве

Creating a report of parent records with associated tasks - (No Sound)

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.