Way to do a query subset?

[jmunning]

Does Siena have the ability to perform a query, retrieve rows and then reuse that set of rows in multiple queries with different filter params?

i.e.   List<Foo> foos =  Foo.all().filter("bar", "baz").fetch()

and then perform queries against this subset?

Thanks.

[Antonio de Sousa Barroso]

Hi,

the answer is yes, but the filter will be in the subset of results obtained in the previous (left) filter expression:

// Retrieves all the events of user for particular team (users can belong to more than one team)

Events.all()

          .filter("team", team)

          .filter("member", member)

          .order("-start")

          .fetch(); 

I hope this can help you

Antonio