web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Having Clause not working

(0) ShareShare
ReportReport
Posted on by

When we are trying to apply having clause with complex Dynamics AX query it does not reflect any changes.

Kindly provide me detailed document on how to apply having clause in effective manner?

We have already referred this link.

https://msdn.microsoft.com/en-us/library/hh745337.aspx 

Please provide us any other document which will help us on how to apply having clause with Dynamics Ax query without using X++ code.

*This post is locked for comments

I have the same question (0)
  • Chaitanya Golla Profile Picture
    17,225 on at
    RE: [URGENT] Having Clause not working with Dynamics AX

    Hi,

    If possible, can you share your query with us, such that we can check.

  • Dhruvin Shah Profile Picture
    on at
    RE: Having Clause not working

    AOT query

  • Dhruvin Shah Profile Picture
    on at
    RE: Having Clause not working

    Sure.

    Currently I am testing the result using only one table.

    We have added DirPartyLocation in our query and I only need data whose IsRoleInvoice = 1

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans