LiveReport and User Permission

Stephane_Desangles

Hi everyone,I've created a liveReport which list some object by permission.I use a parameter called %5 and define by "filter by permission" but I receive an error :The multi-part identifier "DTree.PermID" could not be bound. If I delete this condition, my Request works. So I don't understand why this request doesn't work.Parameter 1 to 4 are User inputThis is my Request :SELECT a.DataID, a.VersionNum, a.SubType, a.Name, z.DocID, z.FileName, b.ValStr AS domaine, c.ValStr AS theme, d.ValStr AS formulaire, e.ValStr AS localisation FROM livelinkdb.LLAttrData b INNER JOIN livelinkdb.DTree a ON b.ID = a.DataID AND b.DefID = 2964379 AND b.AttrID = 2 AND a.VersionNum = b.VerNum LEFT JOIN livelinkdb.DVersData z ON b.ID = z.DocID AND a.VersionNum = z.Version AND b.DefID = 2964379 INNER JOIN livelinkdb.LLAttrData c ON c.ID = a.DataID AND c.DefID = 2964379 AND c.AttrID = 6 AND a.VersionNum = c.VerNum INNER JOIN livelinkdb.LLAttrData d ON d.ID = a.DataID AND d.DefID = %3 AND d.AttrID = %4 AND a.VersionNum = d.VerNum INNER JOIN livelinkdb.LLAttrData e ON e.ID = a.DataID AND e.DefID = 565056 AND e.AttrID = 5 AND a.VersionNum = e.VerNumWHERE ((a.VersionNum <> 0 AND z.DocID IS NOT NULL) OR (a.VersionNum=0 AND z.DocID IS NULL)) AND (d.ValStr = 'oui') AND (c.ValStr IS NOT NULL) AND (e.ValStr IS NOT NULL) AND (c.ValStr LIKE %1) AND (a.UPermissions <> 128) AND (e.ValStr LIKE %2) AND (a.DataID NOT IN (SELECT id FROM livelinkdb.gdcRecycleBin) ) AND %5GROUP BY a.DataID, a.VersionNum, a.SubType, a.Name, z.DocID, z.FileName, b.ValStr, c.ValStr, d.ValStr, e.ValStr ORDER BY a.NameDoes anyone already saw this problem?Thank you for your help.Frédéric LOSSON.

Martin_Gäckler

You gave DTREE the alias name a, Livelink does not know this alias name and uses dtree instead. Some versions of oracle do not allow to use an alias name AND the original name of a table in one statement.