|
Wednesday 11 June 2008 10:34:02 am
Hi. I have two clases. A class has one attribute as object relation to class b. Btw, i'm using eZ 4.0 for this. what i want is to know wich A objects are reverse related to some B objects. So, i'm doing
{def $contents=fetch( 'content', 'reverse_related_objects',
hash( 'object_id', $b_object.contentobject_id,
'attribute_identifier', 371,
))}
This works perfeclty. Problems begin when i try to order "$contents" by one attribute from A class. This attribute is a numeric value.
{def $contents=fetch( 'content', 'reverse_related_objects',
hash( 'object_id', $b_object.contentobject_id,
'sort_by', array("attribute", "false()", "a/numeric_field")
))}
I'm getting an sql error here. Debut output says
Query error: Column 'contentclassattribute_id' in where clause is ambiguous. Query:
SELECT
ezcontentclass.serialized_name_list AS class_serialized_name_list,
ezcontentclass.identifier as contentclass_identifier,
ezcontentclass.is_container as is_container,
ezcontentobject.* , ezcontentobject_name.name as name, ezcontentobject_name.real_translation
FROM
ezcontentclass,
ezcontentobject,
ezcontentobject_link
, ezcontentobject_name
, ezcontentobject_attribute a0
WHERE
ezcontentclass.id=ezcontentobject.contentclass_id AND
ezcontentclass.version=0 AND
ezcontentobject.status=1 AND
a0.contentobject_id = ezcontentobject.id AND
a0.contentclassattribute_id = 341 AND
a0.version = ezcontentobject_name.content_version AND
( a0.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & a0.language_id ) ) & 2 ) )
<
( a0.language_id & 1 )
+ ( ( a0.language_id & 2 ) )
)
AND
ezcontentobject_link.op_code='0'
AND contentclassattribute_id=371 AND ( relation_type & 8 ) <> 0
AND ezcontentobject.id=ezcontentobject_link.from_contentobject_id AND
ezcontentobject_link.to_contentobject_id=91887 AND
ezcontentobject_link.from_contentobject_version=ezcontentobject.current_version
AND ezcontentobject.id = ezcontentobject_name.contentobject_id AND
ezcontentobject.current_version = ezcontentobject_name.content_version AND
( ezcontentobject_name.language_id & ezcontentobject.language_mask > 0 AND
( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 1 )
+ ( ( ( ezcontentobject.language_mask - ( ezcontentobject.language_mask & ezcontentobject_name.language_id ) ) & 2 ) )
<
( ezcontentobject_name.language_id & 1 )
+ ( ( ezcontentobject_name.language_id & 2 ) )
)
ORDER BY a0.sort_key_string DESC
for simplify, error is telling about an ambigous field in the query in the where clause. i think this line
AND
ezcontentobject_link.op_code='0'
AND contentclassattribute_id=371 AND ( relation_type & 8 ) <> 0
Is this a bug?
|