I've seen this behavior through a dashboard where the first time you open the dashboard it sorts correctly, then if you refresh it sorts differently (usually reverse). In our case I see it mostly when we have groupings set up. We're on the same version, non-unicode tho.
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Friday, March 21, 2014 8:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ sort not work
Good Day:
RE: BAQ sort not work
The sort in BAQ seems incorrect and erratic. Sometime it works, but other times not; also, if you run it twice in a row, it sorts differently.
I am running it from the design program. It also fails if a quick search or a BAQ-tab search.
I used to think it was because of complex table links, or aggregate tables; but I just did a test with just the JobHead table and it did not work. I tried putting the 'sort' column in different places but it did not help. I also tried different columns types: character, date, number.
I never cared, because the "Grid-sort" after it runs, does work, but I want to sort by three fields for the BAQ I am working on.
Anyone have the same problem, or know a solution?
Sun is on E9 Version: 9.05.700C - SQL- Unidata - Enterprise-since 10/15/2012
Went live on 9.05.600B on 11/22/2010
Len
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
________________________________
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Len Hartka
Sent: Friday, March 21, 2014 8:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BAQ sort not work
Good Day:
RE: BAQ sort not work
The sort in BAQ seems incorrect and erratic. Sometime it works, but other times not; also, if you run it twice in a row, it sorts differently.
I am running it from the design program. It also fails if a quick search or a BAQ-tab search.
I used to think it was because of complex table links, or aggregate tables; but I just did a test with just the JobHead table and it did not work. I tried putting the 'sort' column in different places but it did not help. I also tried different columns types: character, date, number.
I never cared, because the "Grid-sort" after it runs, does work, but I want to sort by three fields for the BAQ I am working on.
Anyone have the same problem, or know a solution?
Sun is on E9 Version: 9.05.700C - SQL- Unidata - Enterprise-since 10/15/2012
Went live on 9.05.600B on 11/22/2010
Len
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
________________________________
This e-mail and any attachments may contain proprietary and/or confidential information. If you are not the intended recipient, please notify the sender immediately by reply e-mail or at 410-472-2900 and then delete the message without using, disseminating, or copying this message or any portion thereof. With e-mail communications you are urged to protect against viruses.
[Non-text portions of this message have been removed]