# relation with null value

**URL:** <https://forum.servoy.com/t/relation-with-null-value/1300>\
**Category:** Classic Servoy\
**Created:** [February 18, 2004, 7:39pm UTC](https://forum.servoy.com/t/relation-with-null-value/1300 "2004-02-18T19:39:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [February 18, 2004, 7:39pm UTC](https://forum.servoy.com/t/relation-with-null-value/1300/1 "2004-02-18T19:39:26Z")

</div>

I built a relationship on two values:

organizationid = organizationid  
globals.value = invoicesid

globals.value is in this case empty… (Is it really “” or is it null)

Now I don’t know if this is possible but what I try to archieve is find all orders in this case where the organizationid = organizationid and the invoicesid is still null (or empty).

How can I do this? What I defined above doesn’t work…

1. organizationid = organizationid works…
2. invoicesid = nullable…

---

<div class="post-metadata">

**Author:** ![jcompagner](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/jcompagner/32/4889_2.png) [@jcompagner](https://forum.servoy.com/u/jcompagner)\
**Post date:** [February 23, 2004, 10:32am UTC](https://forum.servoy.com/t/relation-with-null-value/1300/2 "2004-02-23T10:32:23Z")

</div>

the problem is that in youre case the global is “”  
to set the global really to null you have to set it through javascript:

global.xxx = null;

then the related foundset should return the values where xxx is null …

---

<div class="post-metadata">

**Author:** ![IT2Be](https://avatars.discourse-cdn.com/v4/letter/i/dc4da7/32.png) [@IT2Be](https://forum.servoy.com/u/IT2Be)\
**Post date:** [February 23, 2004, 10:41am UTC](https://forum.servoy.com/t/relation-with-null-value/1300/3 "2004-02-23T10:41:51Z")

</div>

Thanks Johan, it works now!!!