I'm aware of table [report_stats] and the definition I have for this table is: The report_stats table in ServiceNow is used to store statistical data about reports, helping users analyse and optimise report performance and usage. I can see there is a...
Hi All,Tried to include variables in the list report but got below error. Also checked the variables for the values which is not empty and not break/container. Syntax Error or Access Rule Violation detected by database (Unknown column 'sc_item_option...
Scenario: I need to enforce a rule where users cannot close a task unless the Email field in the sc_req_item table is filled. What I Did: I created a business rule to check if the Email field is empty, and prevent the task from being closed. Issue:Th...
Hi All, We are receiving multiple sys_id from the recordsIds but the code is not working properly var recordIds = input.controller;gs.addInfoMessage('test'+recordIds); var tag=recordIds.forEach(getTags);// gs.addInfoMessage(tag);} function getT...
In Committee approval Date field the date too be displayed (user should enter between those two dates) should be between RITM created date and today's date. Can anyone please help me with the solution. todays date 28-11-24 == 22-11-24 Thanks in a...
Hi Community, I have 2 tables on which i am pulling the data via integration. 1st table has po number field and second table has po id field. Now, i have the third table where po number and po id both fields are there. Now, if both po number and po i...
i am trying to set values in below fields but not able to set for some fields in imac form :To/New Office Location Date ReceivedIMAC Items> Model/Part NumberAdd a link to the IMAC to the SCTask work notes DescriptionCreate UI action to create an...
Hi everyone, I have an issue wherein I cannot upload XML from my previous instance which was reclaimed, to my new instance (both are same version - Vancouver). I tried uploading a lot of times but the XML file doesnt show up in the Retrieved update s...
Hi, I have a requirement like to get the duration of incident goes from open to pending and open to closed. For this scenario1 is to get the duration of an incident goes from open to Pending .For this I created a metric definition and after that I cr...
Hi All, I am trying to add the value dynamically in the select box for one of the group of users by using below catalog client script... function onLoad() { var selectBox = g_form.getControl('what_is_this_request_for'); var Compuser = new Glide...
Hello Community,I have a requirement where, if a user tries to access a specific catalog item, they should be redirected to another URL.I created a client script for this "function onLoad() { window.location.href("www.youtube.com");}", and it work...
Hello, I wanted to know how to set mandatory fields through a scripted REST API without enforcing a data policy. I am creating a record in a table based on the request of the payload. I want to make some fields mandatory, only then it should accept t...
NAT setting managed by ServiceNow
I have one variable return date on catalog item and I am using flow designer for my catalog item, After closing one task I am putting RITM into pending requester and that time one variable will visible for user " return date" and when he will submit ...
How to add a custom table record number searchable in portal like how ritm and incident number searchable in portal.
| User | Count |
|---|---|
| 31 | |
| 14 | |
| 10 | |
| 10 | |
| 10 |
