Filter the records which has zero value after Sum(field) x++ / Query class / View

(0) Share

Report

Posted on by MUHAMMAD HAARIS

770

Hi All,

This job will iterate 1500 records in queryRun as per my query. That's correct. Among that, there 5 records only has Qty > 0. How can i filter the same in above query class?

I have added group by of Item Id and InventDimId. And Sum of Qty field.

Thanks.

7888.QueryClass.jpg

All responses (4)

Answers (0)

Martin Dráb 232,968 Most Valuable Professional on at

Like (0)

Report

RE: Filter the records which has zero value after Sum(field) x++ / Query class / View

We can do it. With "having", mentioned above.

By the way, if you wanted to do it in T-SQL, you would need the same thing: HAVING.
Community Member on at

Like (0)

Report

RE: Filter the records which has zero value after Sum(field) x++ / Query class / View

Hi,

I don't think we can filter on the sum of qty in the query.

But it's feasible to make it with T-sql and the post below explain how to make it.

(community.dynamics.com/.../executing-direct-sql-statements)

regards,
Suggested answer

Martin Dráb 232,968 Most Valuable Professional on at

Like (0)

Report

RE: Filter the records which has zero value after Sum(field) x++ / Query class / View

Which version of AX is it about? You can do it with "having", which was introduced in AX 2012, I think. Another approach would be using a summarized view.
WillWU 22,352 on at

Like (0)

Report

RE: Filter the records which has zero value after Sum(field) x++ / Query class / View

Moved to Dynamics AX forum.