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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Can't add a range ...
Microsoft Dynamics AX (Archived)

Can't add a range to composite query where JoinMode is ExistsJoin

(0) ShareShare
ReportReport
Posted on by TobyJ

I have an AOT query that has the SalesTable as a datasource and joins to CustTable (JoinMode: ExistsJoin). I can add ranges on both the SalesTable and CustTable datasources.

When I create a composite query using this query I can add an additional range to the SalesTable datasource but not the CustTable datasource.

It seems only to be the case with ExistsJoin and NoExistsJoin as InnerJoin works as expected. Is this a limitation of composite queries in AX and can anyone suggest a solution that has maybe encountered this before? My next step was to look at how I can set this range in code.

Thanks,

Toby

*This post is locked for comments

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans