fetching data from the linked table using query def in web application
Hi Team,
I'm trying to fetch the super team field data in relationship manager table and which is linked from recipient to relation ship manager as 1 to 1 cardinality.
I'm using below code to fetch them
----------------------------------------------------------
var recipientquery = xtk.queryDef.create(<queryDef schema="nms:recipient" operation="select" >
<select>
<node expr="@id"/>
<node expr="[relationshipManager/@superTeam]" alias="@superTeamDec"/>
<node expr="Smart(Lower(@firstName)) + ' ' + Smart(Lower(@lastName))" alias="@fullName"/>
</select>
</queryDef> );
var recipientData = recipientquery.ExecuteQuery();
------------------------------------------------------------
But I'm getting below errors [Highlighted in red]
Note: Here the table name and field name configured correctly as per the instance but still facing issue.
Could you please help to fetch the data.