XtendM3 filter on index 10

unknown

Hello,

Is it available to filter table by index 10 with different orders of keys?

for example, if index 10 keys are CONO, DIVI, FACI, WHLO, HLDR, ITNO. Can I filter by CONO, DIVI and HLDR only?

I've tried this but get no records found

Find more posts tagged with

M3 Development

Accepted answers

unknown

Hi youmna

This approach won't work.

Check if you have any index that has order of CONO, DIVI, HLDR ......., so that you can use read all with the number of keys set to 3.

Else you have to use <span class="n">ExpressionFactory.

All comments

unknown

Hi youmna

This approach won't work.

Check if you have any index that has order of CONO, DIVI, HLDR ......., so that you can use read all with the number of keys set to 3.

Else you have to use <span class="n">ExpressionFactory.

unknown

Thank you. I needed to confirm this

antonio-caria

Sudhakaran as right

Use ExpressionFactory

Use always ExpressionFactory to avoid this kind of problems.

This ExpressionFactory You can almost real SQL - no joins,subselect, exists.. possible.

And You cannot compare the columns between them...

order by is possible

Copyright © 2025 Infor. All rights reserved.