Hi All,
Environment : D365Fo
Usually for Query lookup with ranger we can achieve below code.
queryBuildRange = queryBuildDataSource.addRange(fieldNum(Table,Enum));
queryBuildRange.value(enum2str(Enum:: Values));
Same like above code, How we can pass default values in systemDefinedFilterpane, please below image.
pass default value in Filter.
Just for extra clarification, when you add a filter, you're adding it to data source. A grid bound to this data source shows filtered data and all places where you can see filters (including the filter pane) show the filters. There isn't one set of filters for the grid and one for the filter pane; both take the information from the data source.
Hope the issue is cleated. Please mark the answers as verified, so others can make use of this thread.
It's done by clicking "Did this answer to your question? >> Yes, on the particular reply.
Thanks,
Girish S.
Thanks for your clear explanation.
No, if you add range, it will be applicable to grid and also the SystemDefinedFilterPane.
There is no possibility to apply range only to the filter pane because adding range to the filter pane will filter the data on the grid.
So, the range added to the filters will filter the data on the grid also. Both filter pane and grid or controls will work in accordance with each other.
Thanks,
Girish S.
Hi Girish,
your code is resolved the issues. Thanks
But the code is applied grid values too. Yes the filter field is belong to the table.
is any other code for apply only for the filter?
Hi Dax,
Just add the range like you mentioned.
DataSouceName_ds.queryBuildDatasource().addRange(fieldnum(TableName, FieldName)).value(queryvalue("Some value"));
I think this range will be added to the SystemDefinedFilterPane also.
Thanks,
Girish S.
André Arnaud de Cal...
291,996
Super User 2025 Season 1
Martin Dráb
230,853
Most Valuable Professional
nmaenpaa
101,156