Complex queries with OR and without sysparm_query
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-29-2018 07:22 AM
Hi,
I would like to retrieve list of incidents with this conditions:
(assignment_group=IT Securities AND state IN 'New, In progress') OR number IN 001,002
when I'm using sysparm_query param everything works ok:
.../api/now/table/incident?sysparm_query=assignment_group=5f6441efc0a8010e0177fcb589156352^stateIN1,2^NQnumber=INC0000001
but using this I need to pass assignment_group sys_id and states as int values.
Is there any solution to prepare such query without sysparm_query and pass values as string and still have possibility to add last OR?:
.../api/now/table/incident?assignment_group=IT%20Securities&stateINNew,In%20progress (how insert here ^NQ??)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-23-2021 12:36 AM