CB LIST can i use the sql union all command here?

Hi there,

i'm new with CB and have bought some addons as query, condition, auto actions.
Now i'm trying to use the union command in my list as you can see because in my sql it gives me the perfect result when i do this :

SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks` = "dubbel" UNION ALL SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks2` = "dubbel" UNION ALL SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks3` = "dubbel"

This works fine (what i also need)
(cb_zomerreeks="dubbel" OR cb_zomerreeks2="dubbel" OR cb_zomerreeks3="dubbel") AND (cb_betaald="Ja") AND (cb_zomerladder="Ja")

What i try is this and the system gives me an error by tellin me that the union command is not aloud :

(cb_zomerreeks="dubbel" ) AND (cb_betaald="Ja") AND (cb_zomerladder="Ja") UNION ( cb_zomerreeks2="dubbel" ) AND (cb_betaald="Ja") AND (cb_zomerladder="Ja") UNION ( cb_zomerreeks3="dubbel") AND (cb_betaald="Ja") AND (cb_zomerladder="Ja")

I hope that i can use the union command and that i made a syntax error.

Can you help me please?

Best regards,
Eddy

We can not provide custom coding assistance. Your issue isn't due to the plugin or anything of the sort. You need to provide valid SQL syntax. See the below documentation regarding unions.

dev.mysql.com/doc/refman/5.7/en/union.html

In short each union select query should be surrounded by parentheses.

Hi there,

thx for your answer.
I understand that you can not provide custom coding assistance but when i'm executing this code , following the link that you gave me, it works perfect in the sql database :

SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks` = "dubbel" UNION ALL SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks2` = "dubbel" UNION ALL SELECT `firstname`,`lastname` FROM `tcf2019_comprofilerbackup` WHERE `cb_zomerreeks3` = "dubbel"

When i'm trying to do this in CB for creating a list, it is not possible with the next code in the filters/advanced tab:

(`cb_zomerreeks` = "dubbel") UNION ALL ( `cb_zomerreeks2` = "dubbel")

When i'm changing , in the above line, UNION by OR it works but the the list in cb doesn't output the same name multiple times.
But when you say it is possible, can you provide me a manual instead of the link you gave me so i can look it up.
I have been trying now for 2 hours to get the list in cb that i want but for me it is not possible. I used parentheses everywhere but no result.
Really hope you can help me.

Best regards,
Eddy

You can not do that in userlists Advanced Sorting or Filtering. Those parameters directly tell you what they extend. Sorting adds to the ORDER BY statement of the query. Filtering adds to the WHERE statement of the query. You can not replace the entire userlist query with your own. If you just want to filter off cb_zomerreeks, cb_zomerreeks2, and cb_zomerreeks3 then the below should work fine in Advanced Filtering.

Thx for the explanation. Now i know it's not possible what i was trying and i understand why.

Best regards,
Eddy