Hi Experts, I got a requirement to leave top 100 records and delete the remaining. var gr = new GlideRecord("custom table");gr.orderByDesc('created');gr.setLimit(100);gr.query();while(gr.next()){gr.deleteRecord();} By using above script i am able to ...
I have a requirement to repair one common SLA in each of the incident ticket. I tried doing it in TASK SLA Repair option, but it updates the ticket work note with the wording "User experience SLA has been removed from 'Task' table" and it is updated ...
Hi, Just encountered this simple question, how to set approvers dynamically based on oe catalog variable. I tried to modify the script in multiple ways but not able to fix it. So we have a custom table where we have stored all those servers. In the c...
Hi, I would need to extract all CIs (Irrespective of CI class or category) from my instance through REST call. Which table should I query to get all CIs and their relationships at once ? Is it cmdb_ci and cmdb_rel_ci ? OR If I need to fetch Applicat...
I am using labels as a way to have notes on my forms, but I do not like how they are underlined. Is there a way I can remove this line?Thanks
Hi all, Is it possible to add multiple references/qualifiers in the Dependent Value field for a Choice in a list. The scenario at hand, is I have a custom app that operates across seven regions. The Category dropdown is different for all regions. How...
I want to convert string date (2019-MAR-22) to date format (03-22-2019). Regards, Rushi
Hello, We are currently working on the Order Guide wherein we have almost 30 catalog items to be used and in all the items we have Manager approval.We want a single notification at the order guide level to the Manager which will contain all the Reque...
Hi All, Few questions on SN integration capabilities, 1. How much data can be created/Updated in a third party system via the POST method ? Does SN have any restriction? 2. How much data a third party system can create/update in SN in a given POST ...
Hi, I need my transform map to skip records rather than ignore them if the user ID doesn't exist in the system.
If the field(operational status) on cmdb_ci form is retired then than that ci should not be visible on incident forms ci field ? Someone tell me how to do this.
is there a best practice to use child incidents vs child tasks for child tickets.?
Hi All, Please find the scenario below: I have a UI page with 4 fields. When the field value for one field (field A) changes, I need to check if other three fields are empty or filled. If the three fields are empty, I need to display a message on the...
Hi All Currently we have workflows for adding approvers to change management . The approvers added to the change by the workflows insert a perfect record in sysapproval_approvers table . However , when we are adding an approvere manually to a chan...
