Hi all. I am using Oracle APEX 23.1.5.
I have a progressive web app that should run on Android devices. It shows service providers. Users can rate those providers. There are different rating criteria. For example, Friendliness, products quality and prices are rating criteria.
I have the following tables…
service_provider(id, name).
rating_criteria(id, criteria).
provider_rating(provider_id, criteria_id, rating)
The page that should be used to rate providers would have an item that holds the provider's id, and it should display all criteria, and users should specify a rating for each criterion.
The problem is that Start Rating item only has the rating value. I'd still need the criteria_id to insert them in provider_rating table.
How can I relate criteria id with each star rating item?
I thought about creating an Interactive Grid with an outer join with the provider table to display all criteria id's whether user set their ratings or not.
This the best I could think of. If you have a better solution, I'd appreciate it. Thanks