Model Name in Find Function

Question

Model Name in Find Function

muhammadahsan1991 Jan '16

Created Jan '16	Last Reply Jan '16	Replies 2	Views 355	Votes 0

muhammadahsan1991 14.7k

Jan '16

I want to use another model inside find function like: $conditions = ["id" = $id] Model A::find([ 'conditions' => 'id=:id: AND Model B.created_at Between datefrom AND dateto', 'bind' => $conditions, ]);

Any one can help as soon as possible

Wojciech Ślawski
145.0k

Accepted
answer

edited Jan '16
Jan '16

Use modelsManager for that(joins) or native query if you need to subquery from other table. Model find/findFirst methods are mostly for select without assosciated data, I at leasy use it like this.

Izo · Answer 1 · 2016-01-13T04:50:00-07:00

i remember older posts , and between was a bit scrwed in the parser ( i am not 100% sure ) use


id bla bla ... AND  Model_b.created_at >= |XXX| AND model_b.created_at <= |XXX|

but i am not sure what your problem is ? You did not explain it i think ?

muhammadahsan1991 · Answer 2 · 2016-01-14T02:03:58-07:00

Thanks Jurigag I have used model Manager which give me same array as find function gives.

Use modelsManager for that(joins) or native query if you need to subquery from other table. Model find/findFirst methods are mostly for select without assosciated data, I at leasy use it like this.