Hello, I have a doubt about the best way to do a complex search.

I have a model "Agreements", every agreement entity have a 'state' field,
wich can have the 'expired' value, I want to show all the agreements that
haven't expired, but not the expired ones... with an exception. The
Agreement model refers to another model : AgreementModels , I want that if
there isn't another agreement not expired with a specific model, then the
expired agreement must be shown anyway.

My problem is the last condition, I think I must do at least two searches,
but if there is a way... I'll give a lot of thanks :) .

Thanks in advance!

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
[email protected] For more options, visit this group at 
http://groups.google.com/group/cake-php

Reply via email to