Show specific Choices based on another field choice

[Vengeful]

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.

[Harsh_Deep · Accepted solution]

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.

[Aniket Chavan · Accepted solution]

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

[Harsh_Deep]

Hello @Aniket Chavan 

Same thing you are doing again.
I have already shared the same answer. Then Why you are sending again the same answers on every posts.

If you want answers as a solution accepted then let me know I will delete my answer then you will get easily.

Please be professional.

[Aniket Chavan]

Hello @Harsh_Deep ,

I understand your concerns, and I appreciate your commitment to maintaining professionalism within the community. I want to clarify that my responses are based on independent testing and knowledge.

In a previous instance where you felt the answers were similar, I chose not to escalate the situation as my primary focus is on fostering a positive and collaborative environment. However, as you've raised the issue again, I feel it's important to address it.

For the specific question at hand, I provided a detailed response, including images of my testing process. I have performed the same steps—creating the application, table, catalog item, and corresponding variables—due to the nature of the question. The provided field and variable names were set by the questioner, not influenced by your response.

Additionally, if we want to restrict the choices based on any other selected variable choices, there are very limited ways to do it; one is calling a script include, and the second one is a reference qualifier. I chose to go with a reference qualifier since it's an easy choice to avoid the script include. Now, since the variable and field names are provided by the questioner, not by you, they are going to be the same. So, using the same field and variable names does not imply copying your answer.

I've noticed your active participation and strong profile in terms of replies and accepted solutions. I respect your experience and contributions to the community. However, I still feel that you are new here, and if you didn't know how the community works, I'm more than willing to help you understand the collaborative nature of our platform. I believe in an inclusive community where everyone is welcome to share their thoughts and knowledge. In the previous question, Vengeful even tagged me to provide input on a new question, and I responded accordingly.

Let's continue to contribute positively, and if you have any further concerns or suggestions, feel free to discuss them. Our shared goal is to assist and learn from each other, contributing to the growth and knowledge-sharing within the community.

Thank you for your understanding.

Best regards,
Aniket.

[Vengeful]

@Aniket Chavan @Harsh_Deep 

I tried your both reference qualifier but it's not working on my side.

I am thinking maybe because my variable Application is Lookup Select Box.

The lookup is coming from this variable.

[Tai Vu]

Hi @Vengeful 

We need to make sure the Lookup value field in your variable is storing the same value as the Application field in your report table.

Can you help to clarify what is the type of the Application field in your report table?  Is it the Application [sys_scope] reference field type?

Cheers,

Tai Vu