Enhancement suggestion on Window CRM Desktop App
The queryRecord() call is not supported on Windows desktop, however it works for most of the time.
There are some known issue we found, in window desktop app WHERE Clause can't escape certain known SQL keywords, such as "order by", "group by", "join", and "on".
For example:
var objectName = "Key_Message_vod__c";
var fields = ["Vault_Doc_Id_vod__c","Name","Vault_External_Id_vod__c"];
var whereClause = "WHERE Description_vod__c = 'Some text on the use as title' ";
com.veeva.clm.queryRecord(objectName, fields, whereClause, null, null, function (result) {
console.dir(result);
})
This one will return error:
{
"success": false,
"code": 1030,
"message": "queryRecord: Invalid WHERE clause: WHERE Description_vod__c = 'Some text on the use as title'"
}
Please sign in to leave a comment.
Comments
0 comments