Share » Forums » Developer » OR condition in...

OR condition in eZPersistentObject::fetchObject

OR condition in eZPersistentObject::fetchObject

Thursday 07 December 2006 8:44:00 am - 5 replies

Author Message

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

Claudia Kosny

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?

Thanks

Claudia

Kristof Coomans

Friday 08 December 2006 12:37:29 am

Hi Claudia

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?

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org

Claudia Kosny

Friday 08 December 2006 2:13:52 am

Hi Kristof

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

Claudia

kracker (the)

The Doctor

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/

You must be logged in to post messages in this topic!

36 542 Users on board!

Forums menu