Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
We are not completely sure that we understood all the details that you described.
Generally speaking, when we do a "LEFT JOIN" in SQL,
it returns all records from the left (first) table and the matched records from the right (second) table. If there is no match for a specific record, you’ll get NULLs in the corresponding columns of the right table.
How to adress the vars in a joined db?
Per example, I have a mysql-db-structure:
SELECT dict.`de`,
dict.`el`,
dict.`kondek`,
….
kondek.`kon-art`,
kondek.`s1p`,
kondek.`s2p`,
….
FROM dict
LEFT JOIN kondek
ON dict.`kondek` = kondek.`kon-art`
I can name %de%, %el%, … %kondek%, and wpDataTables evaluates them correcly. %s1p%, %s2p% not.
Is wpDataTables not able to do so?
Please, can you help me?
best regards,
Franz Horvath
Hi, Franz
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
We are not completely sure that we understood all the details that you described.
Generally speaking, when we do a "LEFT JOIN" in SQL,
it returns all records from the left (first) table and the matched records from the right (second) table. If there is no match for a specific record, you’ll get NULLs in the corresponding columns of the right table.
You can see more details here, if you wish.
-
I am sorry, but we did not understand what you meant in this part :
' I can name %de%, %el%, … %kondek%, and wpDataTables evaluates them correcly. %s1p%, %s2p% not. '
Could you please elaborate more about this in more details, or even better with a video / and / or screenshots,
so that we can better understand what you mean by this? 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