Complex queries with OR and without sysparm_query

yooreck
Kilo Explorer

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??)

5 REPLIES 5

snow demo
Kilo Explorer
Hi yooreck,
 
did you get the solution for your question. Please let me know the solution