I created a query and made a grid on the form, but when I I filter it still shows blank stuff under it. If I filter for
100 it will show me everything with 100, but if there are fields that are empty in that column, it still shows them as well. Is there a setting a missed?
*This post is locked for comments
You are adding the filter then probably on the wrong table/field if it does not do the filtering for you, since there is no difference between the advance filter screen and the filtering above the grid, or by the field - they all use the same mechanics, so you must be applying the range to the wrong datasource.field.
The findorcreaterange is no different from the addrange, you would just pass in this.queryBuildDataSource() in the init of the inventdim table (if that is what you want to apply the range for), instead of referring it through the query.
I went to your link and followed their instructions. I put this line of code in my init of the datasource.
this.query().dataSourceName('InventDim_1').addRange(fieldnum(InventDim,WMSLocationId)).value(queryvalue('6*'));
The problem is, for one, It's filtering as "6\*" for some reason, and even if it was filtering by what it should be, it's doing the same thing as before. Where it shows the empty records where I filter unless I go into the advanced querying.
I'm not quite sure on how to use SysQuery::findOrCreateRange this is what I found someone else using, but it doesn't seem to be working for me. Getting a syntax error under the dataSourceNo(1).
The filtering in the client is per user unfortunately. If you want it to be permanent, then the range has to be created on that form by a developer in the init method of the datasource.
dynamics-ax-live.blogspot.co.uk/.../how-to-filter-records-in-form-by-code.html
I would use SysQuery::findOrCreateRange in the init, if you always want to filter by a specific value.
Vilmos,
It looks like you were right. When I looked at the advance filtering query it was only showing 2 fields, when I tried to filter from those fields it worked correctly.
So I added in the field that I wanted and it fixed it.
How can I make it stay permanent so users don't run into this problem?
On the columns insidie the grid select Right click > Personalize > System name value to see what tables are in there and whether they are all the same, or different. Alternatively check the Query tab like I suggested above.
In the screenshot I'm filtering the Pattern column by 1001, you can see that it shows 7 records or so, but after that, it continues to show the empty fields. It'll do that no matter what column I filter.
I created a range in a query. It's not code, so it seems to be user.
You can press Control + F3 to see the advanced query filter criterias on your form. If the same field shows multiple times, it acts as an OR operation.
You can also right click on a form control > Personalize > Query tab and see what your relations and ranges are, maybe you will see there what is wrong or missing.
Hi Conficker,
Please tell more about your customization and the current scenario. Would it be possible to share a screenshot, so we can understand what you are actually trying to ask?
#1
Mohamed Amine Mahmoudi
100
Super User 2025 Season 1
#2
Community Member
46
#3
shanawaz davood basha
6
Share
Report
All responses (
Answers (
