How can I create case sensitive glide record query?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2018 03:47 AM
Requirement:
I've to query a table in SNOW, where multiple records records are available with same name(case sensitive).
How can I query specific record using glide record query.
- Labels:
-
Field Service Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-02-2018 07:49 AM
Hi,
The server side GR queries will always be case in sensitive.(as designed)
however you can have a look at workaround from thread.
https://community.servicenow.com/community?id=community_question&sys_id=33008721db98dbc01dcaf3231f9619b2
Thanks
Harshad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 08:24 AM
It doesn't seem to be case sensitive. If I query the core_country table for countries with name "UNITED STATES OF AMERICA" it brings the record with "United States of America" as name.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-25-2021 09:21 PM
Hi gyaneshwarchaudhary,
Check the below link it may be help for you.
https://developer.servicenow.com/dev.do#!/reference/api/orlando/server/no-namespace/c_GlideFilterScopedAPI
Megha
