I created a custom table called 'Report Name'. Then create a catalog item. One of the field is a List Collector.
In the catalog item, I have a requirement that when user select an Application (Select box) sample Fiori, in the Report Name (List Collector) will only display the reports for Fiori.
Report Name table
My challenge is that we have 24 applications and some of the has thousand of reports. But we will reduce these items though.
Hello @Vengeful
You can refer below SS
Mark ✅ Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Hello @Vengeful ,
Please check out the reference qualifier below to see the available "Report Names" options based on the selected application. I created a Fiori application and a table (Report Name) as you requested. I set up variables for Application and Report Names just like yours. When I used the reference qualifier, it worked perfectly. The report names showed up based on the selected application.
Give it a try, and let me know how it goes. If you have any questions or run into any issues, feel free to ask. I'm here to help sort things out. Your feedback is important, and I'm eager to hear how it worked for you.
javascript: 'application.name='+current.variables.application.getDisplayValue();
Please Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.
Thanks,
Aniket
Hi @Vengeful
Thanks for more information. Let try my below suggestion.
Since your Application variable already set the Lookup value field as Text. So, in your Report Name list collector variable, try to set as following:
javascript: 'u_application=' + current.variables.system_application; //your application variable name
(change sytem_application to your Application variable if it's not correct)
Cheers,
Tai Vu
