- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2023 11:29 PM
Hi Team,
Am using below OR condition in the below query, but it shows syntax error
Please guide me
var fieldMappingRef = new GlideRecord('customer');
fieldMappingRef.addEncodedQuery('email=test.test@xyz.com'+OR+'^u_siebel_contactid=11');
fieldMappingRef.query();
if (fieldMappingRef.next()) {
gs.info("enter");
}else
{gs.info("last");
}
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2023 11:38 PM - edited 01-26-2023 11:42 PM
Hi @String Try below Encoded Query.
fieldMappingRef.addEncodedQuery("email=test.test@xyz.com^ORu_siebel_contactid=11");
To get exact encoded query add filter condition on table and copy from there.
If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-26-2023 11:38 PM - edited 01-26-2023 11:42 PM
Hi @String Try below Encoded Query.
fieldMappingRef.addEncodedQuery("email=test.test@xyz.com^ORu_siebel_contactid=11");
To get exact encoded query add filter condition on table and copy from there.
If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!
Thank you