Forums

Chronoforms7: Read DataBase, NOT IN Condition

Colnem 16 Aug, 2021
Hello

There is no "NOT IN" array condition in a Read Database Element, Where Conditions...
How to do like this without use PHP?
Thanks

PS: "NOT" condition doesn't work like "NOT IN" condition in SQL...
Colnem 20 Oct, 2021
Answer
Hi guys.

I've found!

It's necessary to replace 'NOT' => 'NOT' by 'NOT IN' => 'NOT IN' in this files:
1) \administrator\components\com_chronoforms7\chronoforms\behaviors\functions\data_conditions\data_conditions_config.php (line 15 and line 125)
2) \administrator\components\com_chronoforms7\chronoforms\behaviors\functions\data_relations\rconditions.php (line 47)
3) \administrator\components\com_chronoforms7\__shared\models\conditions.php (line 44)

Thanks for myself !!!
simelas 29 May, 2022
Thanks ! :-)
You need to login to be able to post a reply.