posted 15 years ago
Hi
I am using JPA & Ejb3, and I bump into in to this query problem.
I have four tables implemented as entities,
process, group, and relation table between them � process_group,
process_execution_Instance which is the information about running a process.
Example
process =1(id), file integrity (name)
group = 1(id),maintenance (name)
process_group 1(process_id),1(group_id) - relation between the process and the group.
process_execution_Instance � 1(id), 1 (process_id),02-04(date)
The relation between process and group is as follows:
I would like to query all process_execution_Instance of group "maintenance" using JPA Namedquery,
Any help will be appreciated,
Thank you.