Create dynamic finder between two classes in Grails

Question

I have two domain classes (db tables) in my Grails project:

class Doctor {
String role;
String name;
String surname;
String address;
 ...


@NotNull
static belongsTo = [secUser:SecUser]
....
}



class SecUser {

transient springSecurityService

String username
String password
...

}

I would like to find all SecUser that have not a correspondent Doctor.

How can I do it?

What properties do Doctor and SecUser have to link them together? I don't think you provide enough information. — maple_shaft, Apr 23 '15 at 11:02
Doctor belnogsTo Secuser...I think it is enough...what do you need to know also? — FrancescoDS, Apr 24 '15 at 07:21
You need to show a property linking Doctor and Secuser or else how can anybody help you write an HQL query? This is not enough information. — maple_shaft, Apr 24 '15 at 11:12

score 0 · Answer 1 · answered May 06 '15 at 14:04

0

I think you need something like this:

SecUser.executeQuery(" FROM SecUser secUser WHERE NOT EXISTS (SELECT doctor.SecUser FROM Doctor doctor")

answered May 06 '15 at 14:04

David Chavez

617
3
17

Create dynamic finder between two classes in Grails

1 Answers1