# Find/Search Results Capped at 200

**URL:** <https://forum.servoy.com/t/find-search-results-capped-at-200/16092>\
**Category:** Classic Servoy\
**Created:** [June 22, 2012, 12:27am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092 "2012-06-22T00:27:57Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kwpsd](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@kwpsd](https://forum.servoy.com/u/kwpsd)\
**Post date:** [June 22, 2012, 12:27am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/1 "2012-06-22T00:27:57Z")

</div>

Version: 6.0.6 - build 1232

A table has 1091 records. In this table, there are 971 records whose column named ‘period’ contain an empty string (‘’). The following find/search code is used to extract the 971 records (numbers verified using SQL Explorer):

```auto
    var fs = databaseManager.getFoundSet( databaseName, tableName )
    
    if ( fs.find() )
    {
        fs.period = ''
        
        var recordCount = fs.search()
        
        <remainder of code>
    }

```

The variable ‘recordCount’ always returns a value of 200. Should it not be returning the number of records found (971)?

Any help or suggestions appreciated…thanks!

---

<div class="post-metadata">

**Author:** ![ptalbot](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/ptalbot/32/4952_2.png) [@ptalbot](https://forum.servoy.com/u/ptalbot)\
**Post date:** [June 22, 2012, 1:27am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/2 "2012-06-22T01:27:41Z")

</div>

As usual to know the exact number of records in the foundset, you need to use databaseManager.getFoundsetCount(fs);

---

<div class="post-metadata">

**Author:** ![kwpsd](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@kwpsd](https://forum.servoy.com/u/kwpsd)\
**Post date:** [June 22, 2012, 2:22am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/3 "2012-06-22T02:22:03Z")

</div>

I tried that but was getting the full record count of 1091, so I thought something changed. Now, at home, after restarting my computer, I tried it again, and it worked. Some days…

Thanks for reiterating the .getFoundsetCount() yet one more time!

---

<div class="post-metadata">

**Author:** ![ptalbot](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/ptalbot/32/4952_2.png) [@ptalbot](https://forum.servoy.com/u/ptalbot)\
**Post date:** [June 22, 2012, 3:05am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/4 "2012-06-22T03:05:20Z")

</div>

Maybe you did a .getFoundsetCount() on the foundset before the search which is why it was returning the full count?  
Anyway, glad it works for you now! ![:)]( "Smile")

---

<div class="post-metadata">

**Author:** ![m.vanklink](https://avatars.discourse-cdn.com/v4/letter/m/d78d45/32.png) [@m.vanklink](https://forum.servoy.com/u/m.vanklink)\
**Post date:** [June 22, 2012, 6:08am UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/5 "2012-06-22T06:08:54Z")

</div>

I would use this:

```auto
fs.period = '^='

```

This will search for fields containing null or empty string

---

<div class="post-metadata">

**Author:** ![kwpsd](https://avatars.discourse-cdn.com/v4/letter/k/bb73d2/32.png) [@kwpsd](https://forum.servoy.com/u/kwpsd)\
**Post date:** [June 22, 2012, 6:10pm UTC](https://forum.servoy.com/t/find-search-results-capped-at-200/16092/6 "2012-06-22T18:10:59Z")

</div>

Patrick…your guess was close. I discovered that I had two expressions in the debugger; one for a variable based on the foundset count and one evaluating the getFoundsetCount() directly, and I was using the wrong one in my analysis.

Michel…thanks for the tip!