this question might apply to other areas, but I encounter it in the scope of reporting
I have a datamodel that could like:
Restaurant 1 - * Employee - Person
The Employee is a link between restaurant and person and has (enum) a role attribute. Enum has values (cook, waiter, owner, …)
Image there is only a single owner for each restaurant. So functionally there’s a one-to-one. How do I get hold of this owner so it can be a entity datasource for reporting.
I tried/thought of multiple ways to do it, but none to work.
- transient attribute on restaurant -> datamodeller does not allow transient one-to-one
- expression -> dont see any support for this?
- jpql -> jpql dataset is based on attributes, not on entities
- some kind of preprocessing?
I don’t want the user to have to select that entity, the information is already there.