show list of items depend on choice in DropDown
Hello,
I want to display list of food items depends on choice of customer in restaurant dropdown.
How I can achieve this?
Accepted Solution
Updated: 19 Dec 2021 10:38 EST
ING Nederland
NL
Hi @NisargaC, in your scenario I am assuming you have two tables:
- A table with restaurant names.
- A table with menu items related to a restaurant.
So, accordingly we need to create two dropdowns/autocompletes/anypickers.
Your first autocomplete will be sourced by a Dpage calling an report definition, lets say, D_RestaurantList and will store the selected restaurant in a source property, lets say, .SelectedRestaurant.
Then, your second autocomplete will be sources by another Dpage calling another report, lets say, D_RestaurantMenuList and will accept a parameter for restaurant name, which in our case will be .SelectedRestaurant. So, you'll get those menu items which are available only for the selected restaurant.
Please let me know if this satisfies your requirement or if I am missing something here.
Thanks,
Saurabh.
DXC Luxoft
IN
Hi @NisargaC
What is the expected values for choice of customer? Is it something like if customer selects Veg option, you want to display veg food items and on selection of non-veg, want to display non-veg food items?
or the requirement is different?
Capgemini
IN
@srinit from restaurant portal, restaurant owner will add restaurant name. in customer portal dropdown customer should able to see those restaurant names and can select one. according to selected restaurant name I want to show list of food items.
Accepted Solution
Updated: 19 Dec 2021 10:38 EST
ING Nederland
NL
Hi @NisargaC, in your scenario I am assuming you have two tables:
- A table with restaurant names.
- A table with menu items related to a restaurant.
So, accordingly we need to create two dropdowns/autocompletes/anypickers.
Your first autocomplete will be sourced by a Dpage calling an report definition, lets say, D_RestaurantList and will store the selected restaurant in a source property, lets say, .SelectedRestaurant.
Then, your second autocomplete will be sources by another Dpage calling another report, lets say, D_RestaurantMenuList and will accept a parameter for restaurant name, which in our case will be .SelectedRestaurant. So, you'll get those menu items which are available only for the selected restaurant.
Please let me know if this satisfies your requirement or if I am missing something here.
Thanks,
Saurabh.
Capgemini
IN
@SaurabhG7134Thank you