Index with ascending and descending fields

Adri

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

Kishorm

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

No, I'm afraid, not possible.

Slawek

Kishorm

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

Upps, didn't know that

jaclyn

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

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).