dkim18
asked on
tricky hql where clause
Hi,
I am trying perform select hql, but where clause is a bit tricky. I have two classes like this:
+++++++
public class Project extends ActionForm implements java.io.Serializable {
private Long projectId;
private Demographics demographics;
...
...
+++++++++++++
public class Demographics extends ActionForm implements java.io.Serializable {
private Long demographicsId;//pk
private Set projects = new HashSet(0);
...
...
+++++++++++
and it is 1 - N relastionship. I tried this in HQL editor, but didn't return anything.
FROM Project as project where project.demographics.demog raphicsId= '1234'
What hql is going to look like in this case?
thx
I am trying perform select hql, but where clause is a bit tricky. I have two classes like this:
+++++++
public class Project extends ActionForm implements java.io.Serializable {
private Long projectId;
private Demographics demographics;
...
...
+++++++++++++
public class Demographics extends ActionForm implements java.io.Serializable {
private Long demographicsId;//pk
private Set projects = new HashSet(0);
...
...
+++++++++++
and it is 1 - N relastionship. I tried this in HQL editor, but didn't return anything.
FROM Project as project where project.demographics.demog
What hql is going to look like in this case?
thx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.