Thank you for your purchase, and for letting us know you were able to resolve the issue.
Our 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.
Hello,
I am trying to build a table that shows records without a pickup date.
What condition should be used?
If not, can I edit the sql before building the table to something like....
Con_PartRequest.`PUDate` = NULL
Thanks,
Scott
Found it, maybe this will help others...
GUI produces this.
WHERE 1=1 AND Con_PartRequest.`PUDate` = 'NULL'
If I corrected to
WHERE Con_PartRequest.`PUDate` IS NULL
Appears if you change the SQL, when creating it does work correctly
Hello Scott
Thank you for your purchase, and for letting us know you were able to resolve the issue.
Our 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.
Good call on the WHERE clause.
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