Hello,
I need to build a Dashboard/Report on unused Catalog Items. I need the reports by create date
1. From today to a year ago 7/23/25-7/23/24
2. From a year ago to 2 years ago. 7/23/24-7/23/23
I tried with this report but looking at RITMS I am getting catalog items outside of this date range. Any assistance is appreciated.
Also for the report I selected none for the related list condition. Is this correct?
Thanks,
Chad
I would create a database view with a left join. You will have add left join to the list in the view tables section. It would look like this.
You can get the reports this way. I would do an additional one here you add number to the columns and do a filter were number is empty this will give you items that have never been ordered if you have any. Otherwise you can Created to do that date ranges. Just make sure you choose the one with (ritm_sys_created_on) next to it so you run the report on the date range against the request item table.
I would create a database view with a left join. You will have add left join to the list in the view tables section. It would look like this.
You can get the reports this way. I would do an additional one here you add number to the columns and do a filter were number is empty this will give you items that have never been ordered if you have any. Otherwise you can Created to do that date ranges. Just make sure you choose the one with (ritm_sys_created_on) next to it so you run the report on the date range against the request item table.
