Cannot execute queries with constraints on complex types and with an ordering clause. The generated SQL statements is not correct. The ordering field is not included in the output fields, but it's required (on PostgreSQL at least) when there's a DISTINCT.
SELECT * from Document where ecm:isProxy = 0 and content/name = 'testfile.txt' ORDER BY dc:title
SELECT DISTINCT "HIERARCHY"."ID" AS "_C1"
FROM "HIERARCHY"
JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID"
LEFT JOIN "CONTENT" "_F1" ON "_H1"."ID" = "_F1"."ID"
LEFT JOIN "DUBLINCORE" "_F2" ON "HIERARCHY"."ID" = "_F2"."ID"
WHERE "HIERARCHY"."PRIMARYTYPE" IN ('Document', '...')
AND "_F1"."NAME" = 'testfile.txt'
AND "_H1"."NAME" = 'content'
ORDER BY "_F2"."TITLE"
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
- depends on
-
NXP-4464 VCS: allow NXQL to query complex properties
-
- Resolved
-
