Getting Strange row repeat issue in query second page grid.
I have a standard simple query and with 5 items per page settings what is happening for few queries is when you have 7 items 1st item gets shown in second page as second row item again. Has anyone seen this type of issue?
1
2
3
4
5
second page click
6
1
Strange row repeat issue in query second page grid
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: Strange row repeat issue in query second page grid
I have not, but I am curious, do you have a sort on the query and is it determinative ?
Bruce
Bruce
Re: Strange row repeat issue in query second page grid
What do you mean by determinative, Bruce?
Tom - V8.8 build 3137 - MySql / PostGres
Re: Strange row repeat issue in query second page grid
Means that you would get the same sort order each time you run the query. Example. If you have an employee table with an attribute for Sex, and you sorted JUST on Sex, you would get all the females first, then the males. However, within the sex, there would be no guarantee as to the order. If you added the employee # to the sort, then each time it would sort the same way.
Bruce
Bruce
Re: Strange row repeat issue in query second page grid
Ahh, makes sense Bruce.
Tom - V8.8 build 3137 - MySql / PostGres
-
- Posts: 370
- Joined: Sat Apr 28, 2018 3:33 am
- Location: India
- Contact:
Re: Strange row repeat issue in query second page grid
thank you Both. Wow. That was it. Great catching this small thing Bruce. I had an order by that was doing this.