Can I sort a listpage ascending on one field and then descending on a second field?

GTimmers

Can I sort a listpage ascending on one field and then descending on a second field?

I know i can set the SourceTableView property on the page.
I can select multiple fields there. But only set descending or ascending applied to all those sorting fields. Can I set the sorting descending on one field and ascending on another?

Does anybody know?

Thanks you!

TallyHo

GTimmers wrote: »

Can I sort a listpage ascending on one field and then descending on a second field?

I know i can set the SourceTableView property on the page.
I can select multiple fields there. But only set descending or ascending applied to all those sorting fields. Can I set the sorting descending on one field and ascending on another?

Does anybody know?

Thanks you!

No, you can't. You'll be ending up using a temporary source table, creating all logic yourself. A real performance killer.

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV Three Tier' forum]

TallyHo

GTimmers wrote: »

Can I sort a listpage ascending on one field and then descending on a second field?

I know i can set the SourceTableView property on the page.
I can select multiple fields there. But only set descending or ascending applied to all those sorting fields. Can I set the sorting descending on one field and ascending on another?

Does anybody know?

Thanks you!

No, you can't. You'll be ending up using a temporary source table, creating all logic yourself. A real performance killer.