App view filtering doesn't show value for a 2 letter search

(0) Share

Report

Posted on by Community Member

Hpastedimage1624378714479v1.png"/api/data/v9.1/msdyn_richtextfiles(7539E16A-C0D3-4E14-97FC-19E9A29D5C96)/msdyn_imageblob/$value?size=full">/api/data/v9.1/msdyn_richtextfiles(7539E16A-C0D3-4E14-97FC-19E9A29D5C96)/msdyn_imageblob/$value?size=full

I tried to see if there was any advanced querying available with symbols such as *,?,!.

https://docs.microsoft.com/en-us/dynamicsax-2012/appuser-itpro/advanced-filtering-and-query-options

I was not able to get it to work. Thank you for your help.

All responses (4)

Answers (1)

Community Member on at

Like (1)

Report

RE: App view filtering doesn't show value for a 2 letter search

This works for us. Thank you!
Verified answer

Wahaj Rashid 11,321 on at

Like (0)

Report
RE: App view filtering doesn't show value for a 2 letter search

Hi,

Thank you for your query.

When you apply a filter on the lookup field and type 'AL', it applies contains search, that is why you are not getting expected results.

Instead of applying for a row filter, add a Related Entity filter.

Try these steps:

Open Filter pane.

Click Add -> Add Related Entity.

Chose Teritorries (Parent) option (Contains data).

Then in the filter add filter Territory Name equals 'AL'.

This should list all territories where the parent name is exactly AL.
Community Member on at

Like (0)

Report

RE: App view filtering doesn't show value for a 2 letter search

Hi Leah - sorry for the AX link. We have Dynamics 9.2 Online.
Community Member on at

Like (0)

Report

RE: App view filtering doesn't show value for a 2 letter search

Hi Tony,

Can you provide one clear screenshot because original picture is so blurred.

And what app are you using? The second link you provide is AX, if so, you need go to the correct forum.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.