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

I have the same question (0)

All responses (4)

Answers (0)

WillWU 22,361 on at

Like (0)

Report

Moved to Dynamics AX forum.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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,

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No