Microsoft Dynamics 365 | Integration, Dataverse...

Filter not empty inventSiteId from InventDim

(0) Share

Report

Posted on by Richard Gill

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.

public 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?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi Richard gill,

Have you consider adding a range in the view itself instead of code?

Try adding range to field InventSiteId and keep value as empty string "" and check.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Richard Gill 37 on at

Like (0)

Report
Copy link

Link copied!

Hi both,

Its not standard form. Its a new query and view created for testing purpose.

Was this reply helpful? Yes No
GirishS 27,833 Moderator on at

Like (0)

Report
Copy link

Link copied!

Have you tried adding the range in the query itself as mentioned earlier?

I

Thanks,

Girish S.

Was this reply helpful? Yes No