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

How to order by a result set in Query activity?

Avatar

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile

Avatar
Validate 10
Level 1
yueminspb
Level 1

Likes

0 likes

Total Posts

38 posts

Correct Reply

0 solutions
Top badges earned
Validate 10
Validate 1
View profile
yueminspb
Level 1

19-11-2020

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 ?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

59 posts

Correct Reply

26 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile

Avatar
Give Back
Level 4
ParthaSarathy
Level 4

Likes

34 likes

Total Posts

59 posts

Correct Reply

26 solutions
Top badges earned
Give Back
Boost 5
Boost 3
Boost 25
Boost 10
View profile
ParthaSarathy
Level 4

20-11-2020

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

Answers (0)