Hi, Happy new year to everyone.
I need some help on pulling the report. I have a requirement where to pull a report for specific catalog item based on specific variables since i cannot do it directly on RITM table i am trying to pull it from sc_item_option
table. I see this table has lots of data can anyone please suggest what will be the best of doing this.
My requirement is i need to pull a report a on Top 50 application which were submitted via catalog item. Since we have a Application variable’s like Application #1, Application #2,Application #3,Application #4,Application #5 so i am thinking to a pull a report on sc_item_option
table and say Question startswith Application and group by Value and sort by descending which give’s the top to bottom application names.