Forums

Hi. At this link we have instruction for WHERE Statement in CF / CC 5.
https://www.chronoengine.com/faqs/72-chronoconnectivity/ccv5/5215-how-do-i-build-a-where-statement-in-ccv5
But in CF7?
In read data I read this note:
PHP code without tags to return an array of conditions, e.g: return [ ["field_1", 1, "="],["field_2", 2, "!="]];
​
Ok, But this code, that I read in previous faq:
​
return array (":model.column = 'value' OR model.column_2 = 'value_2'");
​
what syntax has in CF7?
​
and this?
​
return array( 'model_id.column' => array('some value', 'another value', . . . ) );
​
Thank you for your reply.

The Where conditions setting in v7 is advanced enough, why do you need to use PHP ?

Hi,
​
If you want to have conditional conditions as posted by email, then you need PHP, the conditions should be in this format:

return [["field", "value", "=="], "AND", ["field2", "xxx", "!="]];