I have some users in sys_user who are managers as well as they are under some manager. I need to create a function which given a user's sys_id, it should return a json object with all it's reportees under him/her (direct and indirect). Using recursi...
I've got a question regarding cascading variables from the order guide (REQ) to the children (RITMs) that are created. this is for a new hire process where the RITM's need to show the variable and detail from the order guide, so that the RITM's and c...
Hi, The Lookup list option is not available on the employee center, however it is working on the Record Producer 'Try It' option. Can somebody please help me to fix this.First screenshot shows the possibility via the Try It option on the record produ...
how to create database view?and what are the beast practices to use database view
Hello, Can anyone help me with this query?
Hello Team , Is there any option / a way to change a Multi row variable set to Single row variable set in catalog item ?
I'm looking to create a report of agents and indicators. The user will input a date range and then the desired output is I can sort of get this with the OOB PA Analytics Hub using a breakdown on the assigned to field but only for one indicator at a...
Hi,I'm new to the servicenow. I have a requirement in service catalog items that is there is two fields one is "location" field another one is "employee" field both are reference fields u_location and u_employee table respectively. if I select a loca...
Hello Experts, I'm having an issue with Mutual Authentication on one of my instance, on DEV Instance it's working without of the issues ( dev instance - connect with vendor dev webservices via certificates ) but on prod I'm getting an error : Reque...
Hi All, I am having a sample change requests field (list type) in table A. When the record on table A gets closed, I am triggering a change task to create. I need to populate change request (reference field) value with the values from the sample chan...
One or our ITIL user deteled draft KB, I can see that KB article is in deleted records. we would like to restore that KB. There is "undelete with related " option available, can we click on that, will there be any other impact ? Please help and confi...
Hi communities, I would need help configuring incidents auto email follow-up and auto mark the case as resolved if no response from the caller to have better manpower efficiency. Requirements as below:1. Email follow-up will be sent out every 6 ...
Hello, I have created a catalog item, and our requirement is, users need to upload 2 mandatory attachments filename1.csv and filename2.csv, If any one of the attachment is not uploaded then alert should populate, So, I observed that when an attachme...
Hi! We have a requirement where we want to query the related list in Table_1 and if there' at least one record in Related_List_1, the Select Box field value will be changed in Table_1 form Sample Details:table_1 = is the current formrelate_list_1 = i...
Hello -We have several API accounts using REST calls within our instances. Our security team asked us to audit what is being done by the API accounts. They have the ITIL role, which gives them base access to all ITSM tables, and some other tables d...
