grailsgrails-ormgrails3

Use dynamic finders with list of Object IDs

With the given class structure

class MyObject {
   Status status;
}

class Status {
   Integer id;
}

I want to use dynamic finders to query based on a list of Status ID values. What I want to be able to do is something like this

MyObject.findAllByStatusInList([1,2,3]);

This does not work though because my list needs to be Status objects. I know I can build a criteria to do this, but I just want to know if there is a way to accomplish this with Dynamic Finders?

Solution

  • You can use the where clause:

    MyObject.where {status.id in [1,2,3]}.find()

    UPD

    Dynamic finders don't support aliasing so Criteria (or DetachedCriteria) is the solution to be used.

    In case if Status class is a domain entity you could retrieve a list of them (or load their proxies) from the database and then query MyObjects by the status list.

    So I see no other appropriate solution but using Criteria in your case.