Hi community,
I am trying to run a sub query to filter on xtkschemas, that are not part of a custom schema. Sharing the query definition for your reference.
var querySchema = xtk.queryDef.create (
<queryDef schema="xtk:schema" operation = "select">
<select>
<node expr = "@name"/>
<node expr = "@namespace"/>
</select>
<where>
<condition expr="@name" setOperator="NOT IN">
<subQuery schema="cus:subSchema" operation = "select">
<select>
<node expr="@name"/>
</select>
<where>
<condition expr="@id > 0"/>
</where>
</subQuery>
</condition>
</where>
</queryDef>
);
var filteredSchema = querySchema.ExecuteQuery();
Error: SCR-160012 Javascript: error while evaluating script 'renameWKF3414/js'.
SOP-330011 Error while executing the method 'ExecuteQuery' of service 'xtk:queryDef'.
WDB-200001 SQL statement 'SELECT E0.sNamespace, E0.sName, E0.sMd5, COALESCE(E0.sLabel, '') || :#(1)# || COALESCE(E0.sNamespace, '') || :#(2)#, E0.sImg, E0.sLabel, IsMemoNull(E0.mData) FROM XtkEntity E0 WHERE (E0.sEntitySchema = :#(3)# AND (E0.sName NOT IN ())) LIMIT 1000' could not be executed. Param(0)= ( Param(1)=) Param(2)=xtk:schema
PGS-220000 PostgreSQL error: ERROR: syntax error at or near ")" LINE 1: ...ntitySchema = E'xtk:schema' AND (E0.sName NOT IN ())) LIMIT ...
Could anyone please help me on this?
Thank you