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.
Question
Indexing columns in IFS APP10 / Aurena
Be the first to reply!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.