Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

Use of group by in update_recordset

Posted on by Microsoft Employee

Dear all,

I am having problem to deal with group by in update_recordset, and also I am not able to use aggregates in update_recordset. I need some alternative suggestion or solution to achieve functionality like update_recordset.

while select forUpdate takes more time in execution rather than update_recordset 

  • Suggested answer
    István Orosz Profile Picture
    István Orosz 2,137 on at
    RE: Use of group by in update_recordset

    Hi,

    Aggregation directly is not possible in an update_recordset (although you can do it in insert_recordset). I would suggest to make a view with the required aggregates and grouping, that can be joind to the set-based operations later.

    Kind Regards,

    István

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans