Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to order by a result set in Query activity?

yueminspb
Level 3
Level 3

Hi Dear Team,

I need make a query result set been order by some column, but I did not find any configuration about this. Please show me how to achieve this ?

1 Accepted Solution
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @yueminspb ,

By default it will be ordered by primary key. To order by specific column (Say, First name), You can place split activity next to query, and you can configure split activity as below to get ordered result.

split.PNG

  • Limit the selected records > Keep only first records after sorting > Select your column and select descending or ascending sort > And in Limits, select size in % as 100 > Finish.

Regards,

ParthaSarathy S

View solution in original post

1 Reply
ParthaSarathy
Correct answer by
Level 5
Level 5

Hi @yueminspb ,

By default it will be ordered by primary key. To order by specific column (Say, First name), You can place split activity next to query, and you can configure split activity as below to get ordered result.

split.PNG

  • Limit the selected records > Keep only first records after sorting > Select your column and select descending or ascending sort > And in Limits, select size in % as 100 > Finish.

Regards,

ParthaSarathy S

View solution in original post