Filter using ChronoConnectivity fields

Filter ChronoConnectivity results using a form field.

Overview

The issue is that retrieved data cannot be dynamically filtered based on user input from a form field.
In the CF read data action, use the 'where conditions' setting to map the database column to the form field value.

Answered
Connectivity v6
ha halimm4m 17 Jul, 2017
Hello,
I have a question regarding filtering results in ChronoConnectivity, I've successfully retrieved all the rows from the db and now i want to filter the results based on one column by using a field, so the user will enter a value in the field and the results will be filtered according to that specific column in the database.
thanks is advance
Max_admin Max_admin 19 Jul, 2017
Answer
Hi halimm4m,

Use the "where conditions" box in the "read data" action:

table_field:{data:filter_field_name}


Best regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
This topic is locked and no more replies can be posted.