Hi,
I have created a View in PhpMyAdmin based on a multi-table join query. The query and the view both return the expected data in PhpMyAdmin.
I'm tring to use the view as data source (source Table) in Chronoforms Read Data action to populate a dropdown on a page with no joy. I tired using a Read Data action with Relations (advanced Settings) but gave up as setting a three-table join had me scratching my head. So I reverted to my View (if only I can get it to work.
The View has 2 fields (product_id and product_name) required to populate the dropdown value and text.
The Option Data of the dropdown is set as {var:model_name.product_id} and {var:model_name.product_name} respectfully.
A Reload event of the dropdown reloads the page with the Read Data action which is in a separate page group.
Can't work out what I've left out.
I have created a View in PhpMyAdmin based on a multi-table join query. The query and the view both return the expected data in PhpMyAdmin.
I'm tring to use the view as data source (source Table) in Chronoforms Read Data action to populate a dropdown on a page with no joy. I tired using a Read Data action with Relations (advanced Settings) but gave up as setting a three-table join had me scratching my head. So I reverted to my View (if only I can get it to work.
The View has 2 fields (product_id and product_name) required to populate the dropdown value and text.
The Option Data of the dropdown is set as {var:model_name.product_id} and {var:model_name.product_name} respectfully.
A Reload event of the dropdown reloads the page with the Read Data action which is in a separate page group.
Can't work out what I've left out.
can you find the View in the tables list in the Read Data action ?
I do not think it will be there, Chronoforms does not access the database views
I do not think it will be there, Chronoforms does not access the database views
You need to login to be able to post a reply.
