What symbol do i use with sysparm to utilize multiple values in my statement? the carot is "AND" but what is "OR"?

dfournie
Kilo Explorer

What symbol do i use with sysparm to utilize multiple values in my statement? the carot is "AND" but what is "OR"?

 

This works ok with one value as my test but I want to query and bring back records for 250 users based on the specific login IDs.

https://csc.service-now.com/sys_user_list.do?CSV&sysparm_query=user_name=rikitikitavi@csc.com

 

I find in the wiki that the ^ symbol will string together multiple values as AND but my query needs a symbol for OR and none is listed in the wiki.

1 ACCEPTED SOLUTION

Jacob_Andersen
ServiceNow Employee
ServiceNow Employee

In order to use the OR operand, simply use:   ^OR .   So example would be:



https://csc.service-now.com/sys_user_list.do?CSV&sysparm_query=user_name=rikitikitavi@csc.com^ORuser...



Hope this helps!


View solution in original post

1 REPLY 1

Jacob_Andersen
ServiceNow Employee
ServiceNow Employee

In order to use the OR operand, simply use:   ^OR .   So example would be:



https://csc.service-now.com/sys_user_list.do?CSV&sysparm_query=user_name=rikitikitavi@csc.com^ORuser...



Hope this helps!