Forums / Developer / OR condition in eZPersistentObject::fetchObject
Claudia Kosny
Thursday 07 December 2006 8:44:00 am
Hi there
How can I create an OR condition in the $cond argument of the eZPersistentObject::fetchObject function? The end result should be something like SELECT * FROM tablename WHERE column_a = 5 OR column_b = 10 .
Thanks
Claudia
Kristof Coomans
Thursday 07 December 2006 11:09:54 pm
Hi Claudia
You will see how the parameter $conds is converted to SQL conditions in eZPersistentObject::conditionTextByRow, but you probably found that yourself ;-) But it doesn't support OR that way.
You'll have to use the last parameter, $custom_conds, which has to be a string of SQL conditions ready to be inserted inside the full SQL query.
independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org
Friday 08 December 2006 12:24:54 am
Hi Kristof
The last parameter in my version (ez 3.8.4) is $custom_fields which allows for operations on fields (like count or sum). I don't see a way to use this for an OR condition. Could you give me an example for what you mean?
Friday 08 December 2006 12:37:29 am
It seems like this parameter was added on the trunk (it will be in 3.9), but only to the fetchObjectList function. Because fetchObject calls fetchObjectList, the parameter can be easily added to fetchObject too. Maybe you can post an enhancement request for this?
Friday 08 December 2006 2:13:52 am
Thanks for the answer. I suppose I will just add the option to add custom SQL to my copy of eZPersistentObject::fetchObjectList and eZPersistentObject::fetchObject. As the parameters are optional this should not have any negative effect on any code that makes use of these functions.
Enhancement request is posted http://issues.ez.no/IssueView.php?Id=9767
kracker (the)
Friday 08 December 2006 3:19:25 am
Thank you for the issue documentation!
<b>Submit your modification back to the community</b>
Link the forum discussion, issue, patch and documentation together for the community to do as you have. or ...
If you do indeed modify your local copy of eZ publish to meet your own needs would you consider posting a 'patch' or diff of the related source code to support the addition of this feature in stock eZ publish, using the issue systems file attachment feature on your issue.
Cheers,//kracker
Member since: 2001.07.13 || http://ezpedia.se7enx.com/
Script start
Module start 'content'
Module end 'content'
Script end
Time used to render debug report: 0.0001 secs