XtendM3 indexes order

unknown

Hello,

I need to understand index order of retrieved data. 

Let me say that I've an index 10 for following keys (CONO, DIVI, FACI, WHLO, HLDR, ITNO) and I need to retrieve data to be ordered based on index 10, but need to retrieve it by CONO, DIVI, ITNO only which require using expression, but I want to use index instead.

So is there a way let me create new index that give me same data order as index 10, but with different order of fields for index like for example CONO, DIVI, ITNO, FACI, WHLO, HLDR?

Rene Bottern

You can use 'ExpressionFactory' to Filter on any of the Fields (not just Key), but be careful, since it might be very slow and resource consuming if you're searching without any matching Index fields.

Another option is to create a NEW API in CMS015 with a matching Index (you can create your own in CRS021) and then use this API instead to extract the Data.