How to sort data from a table?

Hello Freda,

Hope you are well.

We have reviewed your comments and unfortunately you could not view desired data because of you would require to filter out your data for more than one column and the plugin can able to searching on any single value at a time.
But we believe the simple solution for this is to first do export your overall form data(able to apply date filter also) in CSV sheet and after that, you can short out the form data as you need.

Thank you for answer. I need to display the data from the form in real time. In the administration (Advanced CF7 DB), the data is rendered nicely. I need the same for display on a separate page. There must be some solution ??

Below given the sample SQL query, possibly you will get your solution by this

SELECT t1.data_id, t1.value, t2.value
FROM table_name t1
INNER JOIN table_name t2 ON t1.data_id = t2.data_id
WHERE t1.name = ‘cars_type’ and t2.name = ‘cars_color’;