Sorry but I did not quite understand what are you trying to achieve. Can you please describe me more or send me some example/screenshot so I can take a look and give you my suggestion.
As I can see from the screenshot the data in that column is URL links. And unfortunately sorting by URL links is not possible to be alphabetical because the entry for the data in one cell is like https://... and the plugin sorts by that letters not by the displayed text in the cell.
Can you please tell me which table type is it ( manual, MySQL, Excel...)
Maybe the issue is in the query so can you please make a VIEW in phpmyadmin or any other database management system and see if it is returning the right result.
Ok actually I think I see whats happening. it's only displaying the company names where there is the second field available.
For instance we want column 1 to be company, and column 2 to be country, but not all companies have countries so it is displaying only those that have countries?
If that is the case, how do we set it to display all companies even when there is no country?
I think the issue is because our plugin does not support functions in the queries. I can see that you have Groupby lots of inner joins and that is probably the reason why the results are not displaying as it should.
Can you please tell me did you try to make a VIEW?
The code below is the one being auto generated when I build the query from the builder. It even includes them when I don't select a grouping option.
When i do a VIEW all of the correct information is there, so I think its more the joining is removing records without info?
I guess what I can't figure out how to do is build the query in Wptables and have it show rows where there is an empty cell. Does that make sense?
For instance, we have 132 companies, and 85 with countries associated with them. If I add the country column and group by Company Name, still only 85 companies appear, not 132.
Thanks so much for your help, I really appreciate it.
Hi, I am trying to sort a post_title field by alphabetical but it is sticking some out of order at the bottom of the list. any ideas?
Hi hcassin,
Thank you for your purchase.
Sorry but I did not quite understand what are you trying to achieve.
Can you please describe me more or send me some example/screenshot so I can take a look and give you my suggestion.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Harry,
As I can see from the screenshot the data in that column is URL links.
And unfortunately sorting by URL links is not possible to be alphabetical because the entry for the data in one cell is like https://... and the plugin sorts by that letters not by the displayed text in the cell.
Can you please tell me which table type is it ( manual, MySQL, Excel...)
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Bogdan,
That makes sense, I didn't even consider it was sorting the URL string and not the company name string.
This is a MySQL table that I built using the"Generate a query to WordPress database." option.
Thanks
Hi Harry,
No problem at all.
Maybe the issue is in the query so can you please make a VIEW in phpmyadmin or any other database management system and see if it is returning the right result.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Ok actually I think I see whats happening. it's only displaying the company names where there is the second field available.
For instance we want column 1 to be company, and column 2 to be country, but not all companies have countries so it is displaying only those that have countries?
If that is the case, how do we set it to display all companies even when there is no country?
Thanks so much!
Hi Harry,
I think the issue is because our plugin does not support functions in the queries.
I can see that you have Groupby lots of inner joins and that is probably the reason why the results are not displaying as it should.
Can you please tell me did you try to make a VIEW?
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Bogdan,
Thanks for following up.
The code below is the one being auto generated when I build the query from the builder. It even includes them when I don't select a grouping option.
When i do a VIEW all of the correct information is there, so I think its more the joining is removing records without info?
I guess what I can't figure out how to do is build the query in Wptables and have it show rows where there is an empty cell. Does that make sense?
For instance, we have 132 companies, and 85 with countries associated with them. If I add the country column and group by Company Name, still only 85 companies appear, not 132.
Thanks so much for your help, I really appreciate it.
Hi Harry,
If the VIEW is returning the wright results can you please use that query as an input when creating tables and using Add from data source option.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
I got it, thanks1