# Searching on integer column

**URL:** <https://forum.servoy.com/t/searching-on-integer-column/8933>\
**Category:** Classic Servoy\
**Created:** [March 27, 2008, 10:49am UTC](https://forum.servoy.com/t/searching-on-integer-column/8933 "2008-03-27T10:49:30Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [March 27, 2008, 10:49am UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/1 "2008-03-27T10:49:30Z")

</div>

Hi everyone,

I’m having a problem with searching on an integer column of check type on a form using a method - when I search 1 or “1” in the column and then ask for the omitted records, no records are returned. I know about half of the records have this column empty. However, when I sort on this column, the column is correctly ordered.

Any help appreciated,

Thanks in advance,

Ben

Servoy 3.5.3 on WinXPMCE

---

<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:** [March 27, 2008, 11:53am UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/2 "2008-03-27T11:53:57Z")

</div>

why don’t you search like this if (!columnname)…

That will check for the conditions 0 and null

---

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [March 27, 2008, 6:56pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/3 "2008-03-27T18:56:09Z")

</div>

What you are suggesting would work well in a loop, Marcel, but I was thinking more of a method search to get to the empty integer records:

```auto
forms[frmName].controller.find();
forms[frmName].i_printed_already = "null";
forms[frmName].controller.search();

var c = databaseManager.getFoundSetCount(foundset); // this always returns zero...

```

Any other ideas?

Ben

---

<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:** [March 27, 2008, 7:09pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/4 "2008-03-27T19:09:23Z")

</div>

uhmm, if I am not mistaken you should make null a ^.  
But that is by heart…

---

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [March 27, 2008, 7:19pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/5 "2008-03-27T19:19:16Z")

</div>

You’re a genius Marcel - ‘forms[frmName].i\_printed\_already = “^”;’ did it! ![:D]( "Very Happy")

Now, if I could just get in the habit of reading the documentation before bothering everyone here… ![:roll:]( "Rolling Eyes")

Thanks immensely,

Ben

---

<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:** [March 27, 2008, 7:23pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/6 "2008-03-27T19:23:06Z")

</div>

> Now, if I could just get in the habit of reading the documentation before bothering everyone here…

Well, I can create a driver for your…  
Simply donate 100 Euro to me per helpful answer.  
That will teach you ![:)]( "Smile")

---

<div class="post-metadata">

**Author:** ![LOGIsoft](https://avatars.discourse-cdn.com/v4/letter/l/e36b37/32.png) [@LOGIsoft](https://forum.servoy.com/u/LOGIsoft)\
**Post date:** [March 27, 2008, 7:47pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/7 "2008-03-27T19:47:11Z")

</div>

Puti it on my tab for now please… ![:wink:]( "Wink")

Related question: Is there a reason why, after doing the search on the form using ‘^’, the menu item ‘Show omitted records’ returns nothing? Same result when using a method… ![:?]( "Confused")

Ben

---

<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:** [March 27, 2008, 7:54pm UTC](https://forum.servoy.com/t/searching-on-integer-column/8933/8 "2008-03-27T19:54:44Z")

</div>

hmm, not that I can think of no…