- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-28-2017 04:42 PM
Hi,
I am trying to filter the responses for REST query
`https://XXXX.service-now.com/api/now/table/sys_db_object?sysparam_query=sys_nameLIKEDia`
I read that the sysparm_query=column_aISNOTEMPTY would work. As documented in How do I filter empty rows with REST API? I am trying to filter on sysparam_query=sys_nameLIKEDia and failed.
Could anyone point me to the flaw and help me filter the response on string columns.
Thank you
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2017 02:18 AM
Hi,
Just add the following line in your sysparm_query
nameLIKEia
I think sys_name is not a field name?
Thank You
Please Hit Like, Helpful or Correct depending on the impact of response
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2017 02:18 AM
Hi,
Just add the following line in your sysparm_query
nameLIKEia
I think sys_name is not a field name?
Thank You
Please Hit Like, Helpful or Correct depending on the impact of response
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2017 02:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2017 02:40 AM
I wanted to filter the `sys_name` attribute not the `name`. But it seems that I can do string querries only on `name` but not `sys_name`. This answer is good enough for my needs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2017 02:44 AM
Yes sys_name is not an actual field on the table which you are accessing (sys_db_object) and name is the correct field name.
Thank You
Please Hit Like, Helpful or Correct depending on the impact of response