Forums / Developer / Distinct in extented attribute filter

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Distinct in extented attribute filter

Previous topic

Developer

Next topic

Author	Message
Nicolas Lescure	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 Exponential objects relations datatype.
Björn X	Wednesday 31 October 2007 6:50:48 am Sorry distinct can`t be used in a extended attribute filter unless you have it in a sub query in your where clause
Nicolas Lescure	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 Exponential 3.10. All queries with extended attribute filter have a "distinct". And you can add fields in the "select", which is not possible in Exponential 3.9.x. I think I'll patch the kernel.

Author

Message

Nicolas Lescure

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 Exponential objects relations datatype.

Björn X

Wednesday 31 October 2007 6:50:48 am

Sorry distinct can`t be used in a extended attribute filter unless you have it in a sub query in your where clause

Nicolas Lescure

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 Exponential 3.10. All queries with extended attribute filter have a "distinct". And you can add fields in the "select", which is not possible in Exponential 3.9.x.

I think I'll patch the kernel.