cc5 where condition

Hi,
In cc5, i don't understand the syntax of the where condition : "The where conditions in array format: return array("field_name" => "XYZ");"
My field is COPROMOTER and i want to list the record where this field in not null.
Simple isn't it ? But i can't do it ! 😟
Thank you for helping me,
Marc

Hi Marc,

Did you try v6 ? if you are starting a new project then its better to use v6

You may try this condition in v5:
return array(":field_name IS NOT NULL");

Best regards,
Max

Hi Max,
Thank you for your quick response.
I try it but it didn't work...
I don't understand the syntax of these conditions 😟 i am so sorry.
I put two screen capture, maybee i do un mistake...
Thank you for your help,
Marc.

Hi Marc,

You must have the code after a php tag:

<?php
return array(":field_name IS NOT NULL");

Best regards,
Max

Hi Max,
Thank you very much for your help.
I did not understand that it needed a PHP tag, I understood now. Thank you !
The "IS NOT NULL" does not work but "<> ''" works perfectly.
Again thank you and good to you,
Mark.