Attribute filtering in node fetching operations

Thursday 15 July 2004 10:15:42 am

I'd like to use an attribute filter which checks if a given value is in a multivalue-attribute of content objects. However, attribute filtering does not support the sql-operator IN, which checks if a given value is in a multivalue-database field.

Are there any attribute filter extensions around which allow for filter statements like

ExtendedAttributeFilter,array(array('value x' 'IN' 'multi_value_field y'))

I am currently not keen to write this one myself ;-)

Saturday 17 July 2004 7:20:25 am

Hi Paul,

you're really a great blockbuster ;-)

Thanks a lot & kind regards.

BTW. I am going to deploy this feature in new Edition PieServer for ezp Rel. 3.4 ;-)

Volker

Tuesday 20 July 2004 9:15:56 am

Hello

Only could do it now :-(

You can find my mod in the community svn server adding 'like' and 'in' attribute filters:

http://pubsvn.ez.no/viewcvs/community/trunk/kernel/classes/ezcontentobjecttreenode.php

I patched against rev 7077 of the trunk. If you inspect the diffs, you see it is all very easy to do.

To feed an 'in' array, I usually assemble this array as a string from checkboxes inside a form. The form lets the user specify some nifty filters in a trouble ticket like interface.

If you like it, you can fire another suggestion to the ez crew to incorporate both filter options in the standard code base (I already did without success).

Best regards

-paul

(gone until next monday)

eZ Publish, eZ Find, Solr expert consulting and training
http://twitter.com/paulborgermans