How to get the reason that there are date in mysql but not show on grouptable

Support
#1

I have a function that in entity C’s edit screen, I am trying to get a collection of entity A, the relationship between A and C is
A.B.C = C
When I was in cuba 6.x, it works fine.

When I upgraded to cuba 7.x, it didn’t have any errors, but the groupTable didn’t show anything.

I changed eclipselink.sql log level to trace, got the sql from the log file and executed in mysql and the result contained many rows. But in the web browser network, i got a hollow result. There are also no restrictions in the group.

How can I debug this question?

By the way, if I select A collection without the where condition (where A.B.C = :ds$C), I will see the result in cuba 7.x.

#5

Hi, @peace0phmind!

Could you give an example of your query? Or test project with reproduced problem, if possible. I’ve tried to reproduce problem with query select a from abc$AEntity c where a.b.c = :ds$cEntityDs (cuba 6.x condition was where a.b.c.id = :ds$cEntityDs) but it works fine.

Regards,
Sergey