find record with null value

Classic Servoy
1

Hi,

I have a piece of code for finding a record. its working fine if value is not null but if value is null then its giving no result.

if (fsTopic.find()) {

fsTopic.topic_to_participant_role__all_participants.per_id = personId;
fsTopic.topic_to_plan.organizer_id = ‘!’ + personId;
fsTopic.topic_to_plan.delegated_organizer_id = ‘!’ + personId;
fsTopic.topic_to_plan.backup_meeting_organizer = ‘!’ + personId;
fsTopic.search();
}

This is working very fine if i have some value in organizer id, delegated_organizer id and facilitator.per_id. BUT if any of these value is null then its not showing any result.

I tried giving condition as ‘^||!=’ then ‘^||!’ then ‘^|| not like’ but none is working good. Let me tell you, here all values are in UUID. Where personId can never be null and topic_to_plan is relation with planId as same in both the table.

please help me to get right answer

Thank in advance

Nand

2

please some one answer