# invert records

**URL:** <https://forum.servoy.com/t/invert-records/4816>\
**Category:** Classic Servoy\
**Created:** [October 3, 2005, 1:47pm UTC](https://forum.servoy.com/t/invert-records/4816 "2005-10-03T13:47:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![faheemhameed](https://avatars.discourse-cdn.com/v4/letter/f/7ea924/32.png) [@faheemhameed](https://forum.servoy.com/u/faheemhameed)\
**Post date:** [October 3, 2005, 1:47pm UTC](https://forum.servoy.com/t/invert-records/4816/1 "2005-10-03T13:47:53Z")

</div>

I have a relation class\_to\_class\_student (from class table to class\_student table).

I have done a search on a field as

forms.classDetail.class\_to\_class\_student.student\_name = ‘%’;

I have got 45 records in the foundset. The total records in the table is 100.

Then I have another statement run as

forms.classDetail.controller.invertRecords();

But no records displayed instead of showing the other 55 records.

Any idea please?