Skip to main content



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


    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,


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!


André Arnaud de Calavon Profile Picture

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

Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans