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) / How to update the join...
Microsoft Dynamics AX (Archived)

How to update the join in already existed query which was formed dynamically

(0) ShareShare
ReportReport
Posted on by Sanvy 14

We have the query, which is formed in SysQuery form dynamically as

{Query ProjForecastPeriodic object 366ac9c0: SELECT * FROM ProjForecastUnion(ProjForecastUnion_1) JOIN * FROM ProjTable(ProjTable_1) ON ProjForecastUnion.ProjId = ProjTable.ProjId OUTER JOIN * FROM DimensionAttributeValueSet(DimensionAttributeValueSet_1) ON ProjTable.DefaultDimension = DimensionAttributeValueSet.RecId WHERE ((DimensionAttributeValueSet(DimensionAttributeValueSet_1).DEPARTMENTVALUE = N'023'))}

If we give filter with dimension then above query will form with Outer join dimensionAttributeValueSet.

our requirement is this Outer join should be updated with exists join in our classes withouit disturbing the other filters and ranges in previous query. 

Please help us how to make it.

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,045 Super User 2026 Season 1 on at

    Hi Sanvy,

    Please provide more details how you formed this query in the SysQuery form. I don't understand what you did or want to tell us.

    What do you mean with 'If we give filter'? Where do you put the filter or range value? Can you elaborate with more details?

  • Sanvy Profile Picture
    Sanvy 14 on at

    Hi Andre,

    Thanks in advance,

    to copy the data from one model to other model we are giving the filter in ProjForeCastPeriodic dialog as Projects->Dimension.deparment -> 023 for this path(PMA-> Periodic->Forecasts->Copy Forecasts)

    We have ProjForecastPeriodic query, but it is not having the DimensionAttributeValueSet datasource in it.

    But as we are giving the filter with dimension with SFK relation query is forming dynamically as

    SELECT * FROM ProjForecastUnion(ProjForecastUnion_1) JOIN * FROM ProjTable(ProjTable_1) ON ProjForecastUnion.ProjId = ProjTable.ProjId OUTER JOIN * FROM DimensionAttributeValueSet(DimensionAttributeValueSet_1) ON ProjTable.DefaultDimension = DimensionAttributeValueSet.RecId WHERE ((DimensionAttributeValueSet(DimensionAttributeValueSet_1).DEPARTMENTVALUE = N'023'))}

    After this we need to use this query in our customized classes but this outer join should be exists join for us

    Our requirement is how to modify this join only without changing any ranges and filters in that query.

    Thanks

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,045 Super User 2026 Season 1 on at

    Hi Sanvy,

    Can you probably share some screenshots with details you are performing? I'm not able to follow your thoughts. Probably with screenshots it would be more clear.

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
Basit Profile Picture

Basit 1

#1
GL-01081504-0 Profile Picture

GL-01081504-0 1

#1
Roya Profile Picture

Roya 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans