Index with ascending and descending fields

Answers

• Options

  Slawek_Guzek Member Posts: 1,690

  2017-10-10

  No, I'm afraid, not possible.
  
  Slawek
  

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  0
• Options

  Kishorm Member Posts: 921

  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

  1
• Options

  Slawek_Guzek Member Posts: 1,690

  2017-10-10

  Upps, didn't know that

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  0
• Options

  jaclyn Member Posts: 56

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

  0
• Options

  Kishorm Member Posts: 921

  2017-10-11 Answer ✓

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

  5