Container and unbounded string (text) fields are not allowed in a WHERE expression.

Finance and Operations/AX Developer Forum
1

Is there any way to “bound” a string in a where expression? DocuRef.Notes is unbounded so it errors. Here is the code:

while select forupdate docuRef

where docuRef.RefTableId == TableNum(SalesTable) &&

docuRef.Name == ‘Order Notes’ &&

docuRef.TypeId == ‘Note’ &&

docuRef.Notes like “SearchString” // ERROR HERE

{

docuRef.TypeId = ‘NewType’;

docuRef.update();

}

2

You cannot use the Memo fields in the where expression…

You should find an alternative to achieve the above - like removing it from where expression and using an if condition.

3

Kranthi,

That’s what I thought I might have to do, but I wasn’t sure. 100,000+ records, so it will be slow, but it’s a one time update so we will just roll with it. Thanks for the help!

4

Thank you gentlemen.