Finance | Project Operations, Human Resources, ...

Strange error while Table Browsing entity

(0) Share

Report

Posted on by Tony zhong

903

Hello guys,

I have an entity that when open in Table Browser, showing error like this:

Fields are not aligned properly for union query with group by list. The select list should contain aggregate fields first and then optionally followed by the complete list of fields in the group by list

The data is displayed though.

Anyone experience this ? what does it mean, search internet with no avail. Build was Ok.

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Sort by

André Arnaud de Cal... 306,725 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Tony,

Can you share how you opened the table browser and which table you try to view?

Was this reply helpful? Yes No
Tony zhong 903 on at

Like (0)

Report
Copy link

Link copied!

Hi Andre,

Actually it was my organization's custom Entity, and open from Visual Studio, like this :

Then it will jump to browser and browse the datasource selected.. There I saw that error message at the top panel of table browser. Understand this could be because that custom having problem (although I;m not the one develop it)

So I just want to know what does the error means so I can start digging.

Thanks

Was this reply helpful? Yes No
Martin Dráb 240,312 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

It sounds like a problem with the query used for the entity. Can you give us more details about it?

Was this reply helpful? Yes No
Suggested answer

Fangyuan Hou on at

Like (0)

Report
Copy link

Link copied!

Hi Tony,

The error throw out from the Kernel, it's checking the Select List in your query and throw out this error, please check your query.

Was this reply helpful? Yes No