Not directly, but with a behavior I did it... In the conditions instead of using 'local'=>'Cascavel - PR'
My behavior check if is a virtualfield and turns the condition query into this: "CONCAT({$this->alias}.city,' - ',{$this->alias}.state)"=>"Cascavel - PR" for example, Em quinta-feira, 5 de dezembro de 2013 00h57min03s UTC-2, Simon Males escreveu: > > You cannot search a virtualField... it is virtual. > > You'll have to search the columns directly. > > On Thu, Dec 5, 2013 at 3:17 AM, André Luis <cava...@live.com <javascript:>> > wrote: > > Hi everyone, i have a table "clients" wich the model is "Client"... and > in > > my table I have the fields "city" and "state" and others... Also I have > the > > following virtualfield: > > public $virtualFields = array( > > 'local'=>"CONCAT(Client.city,' - ',Client.state)", > > ); > > > > When i use a find "all" with the conditions 'Client.local'=>'Cascavel - > PR' > > it works perfectly... but if I try to find with the conditions > > 'Client.local'=>array('Cascavel - PR','Toledo - PR'), cake gives me an > error > > saying that the field Client.local doesnt exists... > > > > Does anyone know where i am wrong?? > > > > -- > > Like Us on FaceBook https://www.facebook.com/CakePHP > > Find us on Twitter http://twitter.com/CakePHP > > > > --- > > You received this message because you are subscribed to the Google > Groups > > "CakePHP" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to cake-php+u...@googlegroups.com <javascript:>. > > To post to this group, send email to cake...@googlegroups.com<javascript:>. > > > Visit this group at http://groups.google.com/group/cake-php. > > For more options, visit https://groups.google.com/groups/opt_out. > > > > -- > Simon Males > -- Like Us on FaceBook https://www.facebook.com/CakePHP Find us on Twitter http://twitter.com/CakePHP --- You received this message because you are subscribed to the Google Groups "CakePHP" group. To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscr...@googlegroups.com. To post to this group, send email to cake-php@googlegroups.com. Visit this group at http://groups.google.com/group/cake-php. For more options, visit https://groups.google.com/groups/opt_out.