Aggregate not sorting by datetime

Hi everyone,

I've created the following aggregate (the PlannedStart attribute is a DateTime) but the sorting in not working (Service Studio 10.0.911.0):I've inspected the Executed SQL and I see no Order By statement there. If I replicate the aggregate using an Advanced Query, it works. 

Do you know what the problem might be?

Thanks!

Solution

Rui Lopes wrote:

Hi everyone,

I've created the following aggregate (the PlannedStart attribute is a DateTime) but the sorting in not working (Service Studio 10.0.911.0):I've inspected the Executed SQL and I see no Order By statement there. If I replicate the aggregate using an Advanced Query, it works. 

Do you know what the problem might be?

Thanks!

Hi Rui,

Could you try the following steps?

1. Delete your current order.
2. Right click your group column and sort.

Hope it helps.


With best regards,
F.Karatay

Solution

Hi Ferhat,

I did what you advised and it worked - thanks!

Anyway, this means the sorting tab in an aggregate does not work when trying to sort a grouped column... I believe this may be a misleading behavior.

Rui

Hello what is the name of atribute you are using to create the group by?


I think you ordering by the wrong atribute. can you please do this:

and see if this will fix the issue?


BR

Hi Carlos,

Yes, that fixes the issue - thanks. However, the issue was created by a misleading behavior in the aggregate editor: if the sorting is defined using the "Sorting" tab, it will not work.

Rui