Chronoforms7: Read DataBase, NOT IN Condition

Co

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...

Co

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 !!!

si

simelas 29 May, 2022

Thanks ! :-)

Forums

Chronoforms7: Read DataBase, NOT IN Condition