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...
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...
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...
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...
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 ...
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...
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?
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 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.
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...
Hello, I want a report which help to toggle between month (January, February......dec). That means If I select January, it should display all the ticket created based on the categories in the month January. I tried the below link and grouped based o...
Recently upgraded to Utah and no longer able to set variable values with the "Set Variable Values" test step on a Reference field type in ATF. Has anyone come across this issue? If so, is it a bug? Do you have a workaround? I appreciate any insight ...
How can I add search bar in the header menu list of my portal ?
Hello folks, i would like to create catalog variable which will be invisible/visible based on the value of different reference variable. Basically, if variable1 referenced value has more than 1 items assigned to it variable2 is visible, if variable1...
Hi All, interactive filters we can apply on Report/Widget at a time.
