How to order by a result set in Query activity? | Adobe Higher Education
Skip to main content
Y
yueminspb
Level 3
November 20, 2020
解決済み

How to order by a result set in Query activity?

  • November 20, 2020
  • 1 の返信
  • 1860 ビュー

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 ?

このトピックへの返信は締め切られました。
ベストアンサー ParthaSarathy

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.

  • 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

1 の返信

ParthaSarathy
Community Advisor
ParthaSarathyCommunity Advisor回答
Community Advisor
November 20, 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.

  • 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

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
契約条件Accessibility statement

Loading footer...