connect 2022 banner tablet connect 2022 banner mobile

How to use a Query Range Status on a Filterable Grid Field in Dynamics AX

By Nicole Gentz | October 3, 2017

I had a recent request to make a field filterable on a grid in Dynamics AX.

Making a field filterable on a grid in Dynamics AX

I checked the form control and saw that the field was coming directly from the datasource. So I checked the usual properties… Allow edit was no on the control and the datasource. Skip was no on both the control and the datasource. I noticed the auto declaration was no, so I wasn’t initially expecting it to be changed in the code.

Checking the form control confirmed the field was coming directly from the datasource.

A quick find for refnum in the code and I noticed the below change:

A quick find for refnum in the code created this change.

They used the range status of hidden to limit the ability to filter on the field. Cool! Something I’ve not used before and wanted to share!

Start the Conversation

It’s our mission to help clients win. We’d love to talk to you about the right business solutions to help you achieve your goals.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X