Hello,
im using this native query and it works fine but i want to know how i can do the Something using queryDef.
this is my native SQL:
var email = NLWS.xtkSession.FormatDataPolicy("lowerCase", email.trim());
var firstName = NLWS.xtkSession.FormatDataPolicy("lowerCase", firstName);
var lastName = NLWS.xtkSession.FormatDataPolicy("lowerCase", lastName);
var sql ="SELECT R0.iRecipientId FROM NmsRecipient R0 JOIN XtkFolder F1 ON (F1.iFolderId = R0.iFolderId) WHERE LOWER(R0.sFirstName)='"+firstName+"' AND LOWER(R0.sLastName)='"+lastName+"' AND LOWER(R0.sEmail)='"+email+"' AND F1.sName IN('folder_2','folder_1')";
var idRecipient = sqlGetInt(sql);
Thnaks in advance.