You’re offline. This is a read only version of the page.
37
Hi there,
I am trying to filter not empty values for InventSiteId from InventDim table but it is still showing empty in my view for InventSiteId
First, I created a query with below code and added datasource as InventDim.
Share
Reportpublic void init()
{
super();
QueryBuildDataSource qbdsInventDim = this.query().dataSourceName(tableStr(InventDim));
QueryBuildRange inventSiteIdRange = qbdsInventDim.addRange(fieldNum(InventDim, InventSiteId));
inventSiteIdRange.value(SysQuery::valueNotEmptyString());
inventSiteIdRange.status(RangeStatus::Hidden);
}
I used above query in my view and added fields.
I did build and sync db but I still see empty values in my View for InventSiteId.
I did try creating view based on InventDim and added range for inventSiteId and value as (SysQuery::valueNotEmptyString()) but it is still showing empty values in my View for InventSiteId.
Not sure what is wrong here. It must work with above code. Any suggestion?
Hi both,
Its not standard form. Its a new query and view created for testing purpose.
Hi, Your query looks ok, If its standard form then please check if the range is getting reset. For instance, check executeQuery method of form dataSource.
For D365 F&O queries, you can use below Forum for more suggestions.
community.dynamics.com/.../dynamics-365-for-finance-and-operations-forum
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (