Do we have LIKE / NOT LIKE conditions in ServiceNow to use in Scripting ?
Hi,Do we have LIKE/NOT LIKE conditions which can be used in add Query of the script. ? Just like below in SQL:SELECT * FROM CustomersWHERE Country NOT LIKE '%land%';
Forum Posts
Download file from a 3rd Party system using REST in ServiceNow
Background details I want to download a file from a third party file server. It can store files of all types. Their API only accepts data in the Header (Content-Type and DNT) and the Body comprises of form-data, the form data is some sort of key val...
UI Builder - Contextual Sidebar on Record Page
When creating a custom Case Type, I noticed the Contextual Sidebar in the CSM/FSM Configurable Workspace differs from the custom Case Type and the OOTB Case type. Does anyone know where these are configured? For example, I want to hide a few of the i...
Resolved! REST type in Data source- 'Request action' field is missing
Hi folks, On my PDI (Tokyo) in Data source I don't have access to this field (Request action). This should be visible when I choose Type REST (IntegrationHub). I have installed "ServiceNow IntegrationHub Enterprise Pack Installer" plugin. Also I have...
How to update the roles field with all the roles associated to the user
Hi All, There is a field called roles on the sys_user table which is a list collector, Now we also have a table called sys_user_has_role table where all the roles associated to the user are stored. Can someone provide me a fix script which can look...
Resolved! GlideAggregate MAX aggregation not working properly.
Hi All, Please check the attached screenshot. In Script1, I am using GlideAggregate groupBy function and then doing the MAX aggregation, its giving me the expected output (maximum value from the set of records which were in that group). In Script2, I...
Resolved! How to remove choices of a field inherited from parent table
I have a 'state' field in the pm_project_task table which was inherited from 'task' table. I want only three choices open, closed, cancelled in the state field but it has inherited all the choices. How can I remove those choices? If dictionary over r...
Resolved! Check field value against reference field
Hi, I'm needing to do a check on a catalog item as it is being filled in. I have a text field called:group_name What I want to do is after the field is filled in have it check the sys_user_group to see if a group name already exists that is the same...
How to set group manager as assigned to
On incident table,if we select group for assignment group then how to set manager of that selected group as a assigned to field?
Resolved! Walkup Appointment (wu) record Short Description is updating as undefined.
Hi,when I submit a Scheduled appointment with Walkup Check-in (Walkup Plan your visit) in Employee center I am getting reason as undefined in your upcoming appointments. Also for same walkup interaction I am getting undefined as short description ...
Resolved! Reference field does not show the name shows sysid or date created
I have a custom table with a list of countries that is a reference to another table when i submit data it shows the sysid or the date created for the field and i just want the country name. here below is a screenshot, when i choose United States if s...
How to make options greyed out in a select box variable
There are five options. 1, 2, 3, 4, and 5 in the select box variable of a catalog item. If I select 3, then it should make the other options non-selectable. Can anyone please help me here with how to achieve it?
Communication Plan Help
Hi, This is kind of a difficult problem to articulate. Basically I am attempting to create a client script that will make a Communication Plan available to a Major Incident when certain criteria are met. I can't do this through the normal Filter cond...
How to access /connect end points
How can I access the Connect Conversation REST endpoints in ServiceNow?I'm having trouble finding information regarding the /api/now/connect/conversations/ endpoint. I would like to know how to enable and utilize this feature for other applications.
Integrating ServiceNow for Agent Transfer: How to Create Chats from External Systems?
I have a specific use case where I need to integrate my system with ServiceNow to create chats on behalf of users and receive agents' messages. After researching, I came across the AWA module in ServiceNow, which allows transferring chats to agents u...
