Should be easy but I cannot figure it out. I think I tried everything from the docs.
I have some edit screen with a main data instance, let’s say “companyDc”.
The company entity has a field “city” which is a simple string, no reference.
I want to add a table to the edit screen with all companies in the same city.
So i create a new datacollection “otherCompaniesInTheSameCityDc”.
What is the correct query syntax for “
select e from xx_company e where e.city = companyDc.city”
Mentioning here, replacing
companyDc.city by some static string
I tried everything i found in the docs like “
:param, :component, :container...”, underscores, dollar-signs, jpql_conditions