Report On Varibles Are Not Used Last 12 months

Minh Huy Lam Qu
Giga Sage

‎11-29-2023 05:36 AM

Currently, I am following the same way with Catalog Items that have not been used for 12 months by using the related list condition. However because it is a variable, it is a bit difficult to choose the appropriate table to report. So does anyone have any ideas for reporting on which table? If so, can you guide me on how to do it?

 

Thanks

  • 369 Views
1 REPLY 1

Kristen Ankeny
Kilo Sage

‎11-29-2023 05:58 AM

I'm not sure a report is the way to go with this because you're looking for the lack of something. Instead, I would script this. If you're specifically looking at what variables have not been used in 12 months:

 

If variables for RITMs: use glideaggregate to query sc_item_option (this contains the answers to variables) where the value is not null and created is in last 12 months and get the unique entries into the item_option_new field. This will get you all of the variables used.

 

Then you'll query item_option_new (where variables are stored) and find all of those that are not in the list you retrieved from the above query. That will get you the variables that haven't been used in 12 months.