Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Least ordered catalog items report

RforNewbie
Tera Guru

‎12-11-2023 08:55 AM

How can I make a report of the least requested catalog items of a certain category in the Service Catalog?

I tried using the sc_cat_item table, where I put as filters Sys id is one of the "javascript:new ReportFilter().getItemsInCategory('insertSysID') and I also put a related list "Requested -> item" and "Created at or after last months" . equal to 0
However, the results seem to be incorrect, any idea how I can make this report?

0 Helpfuls
  • 542 Views
1 REPLY 1

KristenA1641094
Kilo Sage

‎12-11-2023 09:05 AM

I would use a database view to do this, join together requested item and catalog item - this would allow you to see the catalog items that have no requested items submitted. Then you can report on that database view to get your analysis.

0 Helpfuls