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.
  • เพลง

ความคิดเห็น •