IGgrid Pagination total records count not updating after search function

When i try to search some records on iggrid using search text box, i get required result on grid but my total records and no. of pages are not updating, they remain same as before search.

after search i got 3 records, but in pagination it shows data

Hello Azhar,

Thank you for posting into our community!

I have been looking into your question and I need to ask for some additional information. Could you please clarify what do you mean by “search some records”? Do you refer to the igGridFiltering functionality?

Additionally, regarding your scenario, I believe that you will find the following sample here quire helpful as it demonstrates how to filter the igGrid using an external input field, i.e., search text box.

Also, attached could be found a small, simplified sample using ASP.NET MVC.

In the attached sample, I am filtering the records by the “Name” field and on my side, everything works as expected. When typing a certain search text in the input field and clicking the “Filter” button, the records and total match count are displayed correctly.

This could be observed in the attachment below:

 

Please test it on your side and let me know how it behaves.

Looking forward to your reply.

Sincerely,
Riva Ivanova
Entry Level Software Developer

Thank you so much,

Actually my query is that suppose after filtering i have 12 employees of same name, but if i have selected page size as 10 i only get one page of 10 employees remaining 2 i don't have any information about, if i keep page size 20 and then i filter i can see all 12 employees on single page.

in my case second new page is not getting added.

Hello Azhar,

Thank you for following up!

I have been looking into your additional question and tested this behavior with the provided sample, however, on my side, I was not able to reproduce it and the matching records count as well as the required pages are displayed correctly.

This could be observed below:

Having this in mind, could you please test this behavior with the provided sample and confirm that the behavior is reproducible?

Additionally, if possible, could you please provide a small sample demonstrating the described behavior on your side?

Having a sample, which I can debug on my side, will be highly appreciated and extremely helpful in providing you with a solution as soon as possible.

Thank you for your cooperation. Looking forward to your reply.

Sincerely,
Riva Ivanova
Entry Level Software Developer

Thanks Riva, 
As i can see you are using Type – Local, and i am using Remote, i don't know wheter i would do any impact or not.

In my case, i have written a javascript function which hits a controller to get the filtered data from database.

In my javascript i have kept the default pageIndex as 0 which only return first page.

could it be the reason in my case remaining records are not added to new page and

also on filtered result page if i change page size in dropdown menu, it refreshes the page which updates the total record count to overall count , changing the filtered result count.
How can i stop it?

Hello Azhar,

I have modified the previous sample to use remote filtering and, on my side, when filtering the records via the search text box, the results are displayed properly.

Additionally, regarding setting the page index to 0, i.e., to the first page, could you please clarify what is the behavior on your side without setting the page index? I am asking this question, because, on my side, if I click on another page to view the results, e.g., page 3, and then filter the results, the filtered results are displayed automatically starting from the first page.

Furthermore, after performing filtering via the search text box and changing the page size, the page refreshes, however, the filtered results remain the same and only the displayed records count for the current page changes as expected.

This could be observed below:

Having this in mind, as I am not sure of the overall configuration of the igGrid, the custom filtering function and the controller that returns the filtered data, in order to assist you further, it would be extremely helpful if you could provide me with a sample that demonstrates the behavior on your side.

Additionally, attached could be found the modified sample for your reference.

Looking forward to your reply.

Sincerely,
Riva Ivanova
Entry Level Software Developer

Thank you Riva, 

I fixed the same issue by fixing my Stored procedure script, i had to do some adjustment to my queries.

Again Thank you so much for helping me out.

Regards,
Azhar 

Hello Azhar,

I am glad I was able to assist you regarding this matter.

Thank you for using Infragistics components.

Regards,
Riva Ivanova
Entry Level Software Developer

It’s interesting to see that adjusting the stored procedure fixed your issue, Azhar. I’ll try reviewing my backend queries as well to ensure the filtered data returns the correct total count.

Just wondering: for Remote filtering, do you always need to reset the pageIndex to 0 after a search to avoid missing records on the next pages? Any tips would be appreciated!