how can I filter the business relation table's phone field

Finance and Operations/AX Developer Forum
1

Hello Everyone,

I need to filter business relation table’s phone field with a filter field. In the phone field of bus rel table consists of both area code and the number. But my filter is only to filter area code. I need to filter like 272*, that is bring me the records that starts with 272 area code.

How can I achieve this? I tried adding range with in queryvalue() but it does not work.

Please help.

Thanks

Erdem

2

I solved this problem.

I used strfmt and then my variable+"*" then it is solved.

Thanks although,

Erdem