Index with ascending and descending fields

Adri · 2017-10-10

I want to create an index with 2 ascending fields and 1 descending field. Is this possible?

Kishorm · 2017-10-11

jaclyn wrote: »

Yes You can use ASCENDING function on any field, you just need to create a key for that field and then use SETCURRENTKEY function on the field before you use ASCENDING on that field.

You don't actually need to create a Key for that field, you can use ASCENDING & SETCURRENTKEY without having to create a key with the fields you want to use.

This was only necessary in older versions of NAV (before the ASCENDING function was available).

Slawek_Guzek · 2017-10-10

No, I'm afraid, not possible.

Slawek

Kishorm · 2017-10-10

Yes, you can do this in later versions of NAV (2016 onwards) by using the SETASCENDING function...

https://msdn.microsoft.com/en-us/library/mt574426(v=nav.90).aspx

Slawek_Guzek · 2017-10-10

Upps, didn't know that

jaclyn · 2017-10-11

Yes You can use ASCENDING function on any field, you just need to create a key for that field and then use SETCURRENTKEY function on the field before you use ASCENDING on that field.

[Ascending :=]Record.SETASCENDING(Field,[ SetAscending])

Customer.SETCURRENTKEY(City,"Name");
Customer.SETASCENDING(City,Descending);

Kishorm · 2017-10-11

jaclyn wrote: »

Yes You can use ASCENDING function on any field, you just need to create a key for that field and then use SETCURRENTKEY function on the field before you use ASCENDING on that field.

You don't actually need to create a Key for that field, you can use ASCENDING & SETCURRENTKEY without having to create a key with the fields you want to use.

This was only necessary in older versions of NAV (before the ASCENDING function was available).

Index with ascending and descending fields

Best Answer

Answers

Categories