Strange row repeat issue in query second page grid

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Strange row repeat issue in query second page grid

Post by swiftinitpvtltd »

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
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Strange row repeat issue in query second page grid

Post by BLOMASKY »

I have not, but I am curious, do you have a sort on the query and is it determinative ?


Bruce
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Strange row repeat issue in query second page grid

Post by tford »

What do you mean by determinative, Bruce?
Tom - V8.8 build 3137 - MySql / PostGres
BLOMASKY
Posts: 1470
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Strange row repeat issue in query second page grid

Post by BLOMASKY »

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
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Re: Strange row repeat issue in query second page grid

Post by tford »

Ahh, makes sense Bruce.
Tom - V8.8 build 3137 - MySql / PostGres
swiftinitpvtltd
Posts: 370
Joined: Sat Apr 28, 2018 3:33 am
Location: India
Contact:

Re: Strange row repeat issue in query second page grid

Post by swiftinitpvtltd »

thank you Both. Wow. That was it. Great catching this small thing Bruce. I had an order by that was doing this.
Post Reply