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'?
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'?
Once I am using the php conditions, how can I make the conditions into 'OR'?
do not use PHP conditions, use SQL Data action or v8 "Where" behavior
for SQL Data you can write the full query however you want
for v8 Where you can write your own where query
for SQL Data you can write the full query however you want
for v8 Where you can write your own where query
You need to login to be able to post a reply.
