Forums

In cf7, in the read data action, how do I make a complicated condition:
I understand how to make a simple condition where I just test for "=" or "!=". It look like this ["Table.Column", "TestValue" , "="].
But how do I test if the Table.Column value is in an array of values? Like this: ["Table.Column", "TestValue1, TestValue2" , "IN"] ?
It doesn't work. Can someone show me how to make it work?

Also, when returning the array of conditions, they are all 'AND'. How do I make them 'OR'?

you can use the SQL data action, and in v8 you can also write the WHERE part of the query directly

But how can I connect the sql data action to the table list view?

you should use the returned data using the variable as the data source for the table view:

{var:sql_data_name}

Back to the original question:
Once I am using the php conditions, how can I make the conditions into 'OR'?