How to put a foreign field in a where clause?

[Eric Maicon]

Sorry if it's a repeated question, but i really didn't find this at the internet....

how can i do this?

Entidade.where("pessoa.somefield", someField).limit(totalPerPage).offset(offset).include(Pessoa.class).toMaps();

Thanks 

[Igor Polevoy]

just saw this, apparently Google is sending emails from this group to Spam folder on... Gmail - go figure. 

this:

Entidade.where("pessoa.somefield = ?", someField).limit(totalPerPage).offset(offset).include(Pessoa.class).toMaps();

will include a foreign key by default if there is a one to many or many to one relationship between Entidade and Pessoa. 

No need to add anything else. 

tx

[Maxime Naus]

Hello,

Is this still working the same way on the current version?


I am trying a similar instruction and it does two queries and not a join between the tables:
The first one is a select * on the table Entidade.
The second one a select... in(" `IDs` of Entidade table returned by the first query").

parameters in the where() method are only applied to the first query so it generates an error as the field "pessoa.somefield" does not exist in the table Entidade.


My goal is to get data from both tables but filtered by where() when I do:  entidades.toJson(true);  (entidades is the list returned by the previous instruction)


Thx in advance.

[Igor Polevoy]

According to documentation: http://javalite.io/lazy_and_eager#improve-efficiency-with-eager-loading it will in fact generate two queries and not a join. 

tx

[Maxime Naus]

OK, thank you for your answer!
I tames your framework gradually.

Br,

Maxime

--
You received this message because you are subscribed to the Google Groups "ActiveJDBC Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to activejdbc-gro...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.