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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

group by in quesy using X++

(0) ShareShare
ReportReport
Posted on by 515

Hi All,

I have created new form lets say SO where I am showing non stocked items which has status !invoiced & !Canceled.Also, I have to consider the SOs which are having non stocked as well as stocked item but the lines with stocked item should have status Invoiced, Delivered.That means if Sales order contains any stocked items with open status then I don't want to display such orders.

I have created query & list page where I am using listpage interaction class.Problem which I am facing are-

1. If I rearranged query with exist join then it will show data in listpage grouped by Sales id but when I press F5 or refresh button it will take some other data too. Salestable is parent datasource & inside that that salesline is added. Due to exist join may be this issue is coming.

2. Now, if I remove exist join then refresh issue will get resolve.but it will show salestable data based on salesline salesid.

Kindly suggest

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    239,419 Most Valuable Professional on at

    It's difficult to comment on your implementation without any information about it. Please show it to us and also look at what query is sent after the refresh ("it will take some other data too" isn't specific enough). QueryBuildDataSource.toString() will help you with the latter task, alternatively you can use native SQL Server tools techniques such as extended events. It's much easier to understand what's going on when you collect enough data.

  • Dhanshri Profile Picture
    515 on at

    Thanks martin for your reply.. i rearranged the query and it worked..

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 39

#2
Michel ROY Profile Picture

Michel ROY 14

#3
imran ul haq Profile Picture

imran ul haq 8

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans