Need to create a report that displays the 5 Oldest catalog task

[keshav77]

Need to create a report in ServiceNow that will display the following two things. The 5 oldest catalog task and  These need to be grouped by Assignment group. 

[Tanushree Maiti]

Hi @keshav77 

• Navigate to Reports > Create New.
• Report name: Oldest 5 Catalog Tasks by Group.
• Source type: Table.
• Table:sc_task
• Click Next. 
• Type: Select List (this is best for viewing specific record details).
• Click Next.
• • Filter: Set Active is true
  • Grouping:
    • Find the Group by dropdown.
    • Select Assignment group
• Limit to Top 5 Records

  option 1 : List View Limit (Recommended for "Oldest")

  • Stay with the List report.
  • Add Sort a to Z
  • 
  • Update related list condition. set the value to 5 as per screen shot.
  • 

[keshav77 · Accepted solution]

@Tanushree Maiti  that doesn't make sense greater then equal to show more then or equal to 5 records.

BTW I have created the solution here it is which show only 5 oldest open task only for particular groups.

We need to create script include for that case and then need to call in report. Below are the screen shot for your reference.