There is a posiibility to add some texfields or something at the GUI to the user can enter values for placeholders and make the query and populate the table depending on thoose values?
Sorry but I did not quite understand what are you trying to achieve, can you please explain me a little more or provide me some example/screenshot so I can take a look and give you my suggestion.
Where that values will be entered in the filters of the table or somewhere else.
On the attached image are two filters (Country and Revenue). What I want to achieve is that the user could enter at those filters some values and make a query to populate my table using those parameters
For example: The user sets 100(as %VAR1%) at Revenue filter and "Spain" (as %VAR2%) at Country filter, so my query for the table will be:
SELECT * FROM my_table WHERE Revenue = 100 AND country = "Spain"
Finally the table will be populated using placeholders (%VAR1% and %VAR1%)
When the users enters that values in the filter the table will be searched for that entries.
The part that I do not understand is how the users should make the query?
You can specify the VAR1 VAR2 and VAR3 in the table settings and use that VARs in the filters or shortcode.
But if you want to do this dynamically, something like, user enter the text in the fields and set the placeholders by entering the values in that filters, unfortunately something like this is not possible to achieve with the plugin built in features at the moment.
There is a posiibility to add some texfields or something at the GUI to the user can enter values for placeholders and make the query and populate the table depending on thoose values?
HI davitx17,
Thank you for your purchase.
Sorry but I did not quite understand what are you trying to achieve, can you please explain me a little more or provide me some example/screenshot so I can take a look and give you my suggestion.
Where that values will be entered in the filters of the table or somewhere else.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
On the attached image are two filters (Country and Revenue).
What I want to achieve is that the user could enter at those filters some values and make a query to populate my table
using those parameters
For example:
The user sets 100(as %VAR1%) at Revenue filter and "Spain" (as %VAR2%) at Country filter, so my query for the table will be:
SELECT * FROM my_table
WHERE Revenue = 100
AND country = "Spain"
Finally the table will be populated using placeholders (%VAR1% and %VAR1%)
Hi davitx17,
When the users enters that values in the filter the table will be searched for that entries.
The part that I do not understand is how the users should make the query?
You can specify the VAR1 VAR2 and VAR3 in the table settings and use that VARs in the filters or shortcode.
But if you want to do this dynamically, something like, user enter the text in the fields and set the placeholders by entering the values in that filters, unfortunately something like this is not possible to achieve with the plugin built in features at the moment.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables