SubQuery Error : Getting error while using subquery in input form | Community
Skip to main content
Level 2
December 23, 2024
Question

SubQuery Error : Getting error while using subquery in input form

  • December 23, 2024
  • 0 replies
  • 402 views

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&colon; 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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.