For example, let's say I want to do this basic query :
SELECT id FROM data WHERE country IN ('USA' , 'France');
If I use a "Where conditions > Condition" with ..Table field name : table.countryCondition : IN... what can I type into the "Value" field ?If it is simpler from "Where conditions > Rules list", what would be the syntax ? I tried many things like ...data.country/in:(USA, FRANCE )data.country/in:( `USA`, `FRANCE`)simple quotes with escapement, double quotes, ... .etc. Each time, it seems like CCv6 treats it as a whole string (surrounded by simple quotes).
I managed to use the "IN" operator with a PHP array returned from another function. But I keep on hoping there is a simpler way to use "IN" than to create an extra function that needs to be (re)declared for each Event.
Also, what is the rules syntax for "NOT IN" ( data.id/not_in: ... , data.id/not in: ... ) ?
At last, how to use a subquery into a "Where conditions" ?
<?phpreturn array( ": data.country In ('USA', 'FRANCE') AND data.country Not In (Select table.name From table) ");?>
<?phpreturn array( ": data.continent In ('Asia', 'Europe') ANDdata.country Not In (Select banned.country_name From banned)");?>
2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by ChronoEngine.com