Buy Now
Sign in

Chronoforms7: Read DataBase, NOT IN Condition

Colnem , August 16 2021, 08:35
C
Colnem 124
August 16 2021, 08:35 #396943
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...
C
Colnem 124
October 20 2021, 09:32 #397265
 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 !!!