# find record with null value

**URL:** <https://forum.servoy.com/t/find-record-with-null-value/18183>\
**Category:** Classic Servoy\
**Created:** [September 24, 2014, 5:22am UTC](https://forum.servoy.com/t/find-record-with-null-value/18183 "2014-09-24T05:22:46Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![nandlalajisingh](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nandlalajisingh](https://forum.servoy.com/u/nandlalajisingh)\
**Post date:** [September 24, 2014, 5:22am UTC](https://forum.servoy.com/t/find-record-with-null-value/18183/1 "2014-09-24T05:22:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![nandlalajisingh](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nandlalajisingh](https://forum.servoy.com/u/nandlalajisingh)\
**Post date:** [September 27, 2014, 12:15pm UTC](https://forum.servoy.com/t/find-record-with-null-value/18183/2 "2014-09-27T12:15:47Z")

</div>

please some one answer