Possible Paging Bug?

[nnavarrete]

I think I may have found a paging bug within Valence 6.1.20220518.0. I am using a form widget as filter for a grid widget. When I press 'Search', a RPG program is called to load data and the grid is set to 'show'-'load data'-'keep behavior filter' on success. Here is the bugged behavior. The

1. Select filters, and press 'search'. The grid displays the records found. In total there are 154, and two pages worth of data. Step1.png
2. Select different filters, and press 'search'. The grid displays the records found. In total there are 278, and three pages worth of data. I change the grid page to three to display the last page of results. Step2.png
3. Select the same filters from step 1, and press 'search'. The grid states 'no results'. Using dev tools, I can see that it tried returning 154 records. Step3.png
4. Select the same filters from step 2, and press 'search'. The grid returns 278 records, and three pages worth of data. It automatically loads to page three, the page I left off on in step 2. Step4.png
5. Select the same filter from step 1/3, and press 'search'. The grid returns 154 records, and two pages worth of data. It automatically loads to page two, the page I left off on in step 4. Step5.png​​

Essentially, I believe the page tracker is not being reset to 1 for each query.

[Johnny Major]

Thank you for the information. We were able to replicate this and will have it fixed in the next 6.1 update

[rdeardorff@spi-ind.com]

either this issue has not been corrected or it has cropped up again in 6.3.20260421. If I filter to a broad selection...then advance several pages into the grid. Then re-filter (without clearing the original) , refining the list so that it would display only 1 page. But I get 0 rows. If I clear the filter and the type 1 in the page number field, and then reapply the filter it finds the data..

[rdeardorff@spi-ind.com]

the key part to remember when re-creating this issue is that the secondary filter needs to refine to a list of less than then number of items represent by the current page you have advanced to using the initial filter.

For example, if the initial filter refines to 250 rows and the number of lines per page is 25 (i.e. 10 pages). If you advance to page 5 (rows 125-150), and then without resetting or clearing the original filter, refilter so that the number of rows refined is only 50 (50 is less than the current line number of the original page 5), the result of this second filter attempt is 0 rows. Clearing the filter (or typing 1 in the page finder) and then reapplying the second filter produces the 50 rows as expected.

I have not tested this in 6.3.20260622.

[Patryk.Wasilewski]

Thank you for the tip but we still cannot replicate this on our end. Please reach out to support@cnxcorp.com so we can schedule a meeting to take a closer look.