Distinct in extented attribute filter

Wednesday 31 October 2007 4:39:44 am

Hi,

I'm trying to create my own extend attribute filter. I need a SQL "in" (ex : li1.to_contentobject_id in (171,139) ). As I'm fetching on objects relation, the query brings me the same object twice (or more).

The solution is to add a "distinct" in the query. But Can I do that with an extend attribute filter ?

Is there another solution ? Any suggestion ?

I'm using the enhanced object relation datatype(http://ez.no/developer/contribs/datatypes/enhanced_objectrelation) instead of the originale eZ Publish objects relations datatype.

Sunday 04 November 2007 10:13:48 am

Thank you for your answer, even if it's not what I expected.

I checked the kernel. It seems my problem is solved in eZ Publish 3.10. All queries with extended attribute filter have a "distinct". And you can add fields in the "select", which is not possible in eZ Publish 3.9.x.

I think I'll patch the kernel.