Index issue

Data Abstract
1

Hi,
I defined “DataSet.IndexDefs” and set “ixDescending = true”. “AutoSortRecords” also set to “True”. But it hasn’t show the indexed records after append the new record. The DASQL has “Order by … desc”. I guess it should be the issue in DAMemDataTable without active sorting.

2

Hi,

where you have declared IndexDefs - on table or table.dataset level ?

3

Hi,
I declared on table level. Then add the new DatasetIndex and set “Fields” for my prefer index field.

4

Hi,

as for me, it

    IndexDefs = <
      item
        Name = 'DatasetIndex1'
        Fields = 'Item1'
        Options = [ixDescending]
      end>
    IndexName = 'DatasetIndex1'
    AutoSortRecords = True

works as expected:
animation

5

Hi,
Thanks. You sample let me know what I’m missing. I missed to assign “IndexName” value. :pray: