The specified sequence of Group By and Order By fields is not supported.

(0) Share

Report

Posted on by itlabnarmi_ivoruk

135

When I debugged code the error is due to AddGroupByField() on query build data-source: qbds.addGroupByField(FieldId)

I have the same question (0)

All responses (7)

Answers (1)

Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Before other development-savvy experts have any thoughts on this, based on the error message, you can check out this link:https://robscode.onl/d365-the-menu-item-with-name-could-not-be-opened/ And check if the fields support grouping and ordering, ensure that the field types used are compatible, and check if the order of grouping and ordering fields is correct.
Best Regards,
Hana

Was this reply helpful? Yes No
itlabnarmi_ivoruk 135 on at

Like (0)

Report

I already gone through this: https://robscode.onl/d365-the-menu-item-with-name-could-not-be-opened/

this is not the same case with me, my issue is due to AddGroupByField() method on data-source.

Was this reply helpful? Yes No
Layan Jwei 8,118 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Can you show us your full code? Where did you use orderBy?

Was this reply helpful? Yes No
Suggested answer

MuthukumaranAX 2,903 on at

Like (0)

Report

is this called from a form datasource or are you constructing the query via code?

Was this reply helpful? Yes No
Suggested answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ itlabnarmi_ivoruk,

It seems you're trying to do order by using group by field. You can't order by Aggregate group by, can you share your code in order to help you better?

Thanks

Waed Ayyad

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
Verified answer

itlabnarmi_ivoruk 135 on at

Like (1)

Report

Thank you guys for your valuable responses, In my case it was some data issue due to which it was throwing this error.

Also I find this below line of code that it might be helpful if there is some sort of issue in group by on query through X++ code:

Was this reply helpful? Yes No
Hana Xue Microsoft Employee on at

Like (0)

Report

Hi,
Thanks for coming back and clarifying this issue, it will help others on the forum with the same problem.
Best Regards,
Hana

Was this reply helpful? Yes No