Show specific Choices based on another field choice

Vengeful
Mega Sage

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. 

Vengeful_0-1708579275843.png

 

Report Name table

Vengeful_1-1708579414286.png

 

My challenge is that we have 24 applications and some of the has thousand of reports. But we will reduce these items though.

Vengeful_2-1708579495998.png

 

2 ACCEPTED SOLUTIONS

Hello @Vengeful 

 

You can refer below SS

Harsh_Deep_0-1708590039033.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

View solution in original post

Aniket Chavan
Tera Sage
Tera Sage

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.

 

AniketChavan_7-1708596221390.png

javascript: 'application.name='+current.variables.application.getDisplayValue();

 

AniketChavan_0-1708595859855.png

 

AniketChavan_1-1708595876856.png

 

AniketChavan_2-1708595908622.png

 

AniketChavan_3-1708595960774.png

 

AniketChavan_4-1708596010694.png

 

AniketChavan_5-1708596042138.png

 

AniketChavan_6-1708596062370.png

 

 

 

Please Mark Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

 

Thanks,

Aniket

 

View solution in original post

11 REPLIES 11

Harsh_Deep
Giga Sage
Giga Sage

Hello @Vengeful 

 

If it is reference qualifier-

Harsh_Deep_0-1708589197252.png

 

In the advance you can mention-

javascript: 'application='+current.variables.application_variable_name.getDisplayValue();

Or

javascript: 'application.name='+current.variables.application_variable_name.getDisplayValue();

 

Above application is backend name of application field for the reference table

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.

HI @Harsh_Deep 

The Report Name field type in the catalog item is List Collector.

Hello @Vengeful 

 

I have edited my response now you can refer.

Hello @Vengeful 

 

You can refer below SS

Harsh_Deep_0-1708590039033.png

 

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.