Chronoforms7: Read DataBase, NOT IN Condition

How to use a NOT IN condition in a ChronoForms 7 Read Database element.

Overview

The CF7 Read Database element's condition builder lacked a direct 'NOT IN' operator for array conditions.
Edit three core CF7 files to replace the existing 'NOT' operator mapping with 'NOT IN' in the condition configuration arrays.

Answered
ChronoForms v7
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 !!!
This topic is locked and no more replies can be posted.