Giving that we have a note and a file that match the following criteria:
SELECT * from Note, File WHERE ecm:isProxy = 0 AND (dc:title = 'testfile1_Title' OR content/name = 'testfile.txt')
This is returning only the file document instead of both the file and the note.
Here is the SQL statement executed:
SELECT DISTINCT "HIERARCHY"."ID" AS "_C1" FROM "HIERARCHY"
LEFT JOIN "DUBLINCORE" "_F1" ON "HIERARCHY"."ID" = "_F1"."ID"
JOIN "HIERARCHY" "_H1" ON "HIERARCHY"."ID" = "_H1"."PARENTID"
LEFT JOIN "CONTENT" "_F2" ON "_H1"."ID" = "_F2"."ID"
WHERE
("HIERARCHY"."PRIMARYTYPE" IN ('File2', 'File', 'Note')
AND ("_F1"."TITLE" = 'testfile1_Title' OR "_F2"."NAME" = 'testfile.txt'))
AND "_H1"."NAME" = 'content'
- depends on
-
NXP-4464 VCS: allow NXQL to query complex properties
-
- Resolved
-
