Hi Team ,
We have following filters for catalog request :
--> Stuck at approved
--> Stuck at Queued
--> Stuck at Submitted
--> Stuck at SPAdmin
--> Stuck at Pending fulfillment
--> Stuck at Pending fulfillment (Report an Issue)
--> Stuck at fulfilled
--> Stuck at pending approval >21 Days
we want to generate a report for the same. .
please help us automate , if you could help me with SQL command or any out of the box catalog feature which can help me automate these .
Good Afternoon Kunal.
An idea to get to the query used internally is:
1. Set the view.log in TRACE mode
2. Execute the search as shown in your screenshot
3. Set the view.log back in INFO mode
4. Check the view.log for the query details
Kind regards, Louis.