Skip to main content
Question

Indexing columns in IFS APP10 / Aurena

  • November 11, 2025
  • 0 replies
  • 4 views

Forum|alt.badge.img+10

Hi,
In Aurena, we have a projection GLVoucherRowsAnalysis
Inside we have the entry date "EntryDate": "2021-01-14T09:46:58Z",
But this field is not in the Voucher Row table, it is in Voucher Table. So this field is not indexed. Is there a way to index it ? or create a custom field that we can index ? I have created Cf_objversion to display the hidden objversion on the row level, but same issue …
How to access the Objversion as it could replace the EntryDate?

The idea is to use this column to create an update query that appends new lines to our Fabric Datalake. But if it s not indexed, the query is very very slow (we use standard Aurena API EndPoint). So it works well on voucherdate, but this date is not interesting for incremental refresh.

0 replies

Be the first to reply!