Report on catalog items

Souvick A
Tera Contributor

‎10-04-2023 06:59 AM

Hello All,

I have a requirement to take report on request item table. The condition is to see which all active catalog items are not being used to create request items for once in last 6 months. There are around 1500 active catalog items and almost 1lac request items created in last 6 months.

Any idea is appreciable. Thanks in advance.

 

Regards

Souvick

0 Helpfuls
  • 555 Views
1 REPLY 1

Jakub_Offierski
Tera Contributor

‎10-04-2023 07:19 AM

For every Active Catalog Item you will have to go to the Requested Items table (sc_req_item) and simply group by Requested Item. That will give you all the counts you need in a list. You can use the same logic to make a Report by selecting Pie Chart from the Item column and it'll start a Report that you can adjust. Just add the timeline criteria to reduce the results to your liking.

 

I suggest you check out some Reporting basics on NowLearning to get more comfortable with Report making.

0 Helpfuls