Is there a way to display serialized data stored in MySQL ? Just something basic like showing all the values comma separated in the same line or something like that
If your SQL query returns serialized values for cells, you will need to modify the query and extract those values.
The plugin doesn't have any features that would do this. You can try with the Query Constructor, but please note that SQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Is there a way to display serialized data stored in MySQL ? Just something basic like showing all the values comma separated in the same line or something like that
Hello Ilia.
If your SQL query returns serialized values for cells, you will need to modify the query and extract those values.
The plugin doesn't have any features that would do this. You can try with the Query Constructor, but please note that SQL query constructor is not an ‘ultimate generator’, it should be treated as helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Kind Regards,
Aleksandar Vuković
[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