I understand it is used to create many to many relationships..However, the first step for creating a m2m relationship, is to create an intermediary table.I've created a table which has only two distinct fields, just location1 and location2 reference ...
Hello All,I have an issue with ACLRequirement is to create an Read ACL to show records which are opened by them , I have created an record type with read operation by Including this script in script boxanswer = current.getValue('opened_by') === gs.ge...
Hello Expert, I tried using below script but no luck. gs.info('attachment test '); var filename; var att = new GlideRecord('sys_attachment'); // Correct the GlideRecord instantiation att.addQuery('table_name', 'incident'); att.addQu...
Hi Everyone,i'm unable to find the table sys_update_set table while trying to create a record through flowdesigner, my flow designer is in HR: Core application scope. is it possible somehow to create a record in update set table through this flowDesi...
Hi, I was running a simple background script to get the sys_id of each record in the table. But I am able to get only 50000 sys_id only even though the table has the more than 1 lac records. Can any one tell me is there any limitation that how many r...
I have a requirement to calculate the duration between two fields from two different tables and i have to show the calculated result in a report. I tried using the database view and i got the required fields from both the tables, but the configure f...
Hi All, Our team is planning an integration between ServiceNow (Incident/Change/CMDB/Tasks/User stories) and Azure DevOps. We will not be using ServiceNow's DevOps (for now). We have found very little documentation with useful info. The documents we ...
Hello experts, I am trying to prevent duplicate software entitlements. If a duplicate is found, I want the request to abort and an error to show up. However, the error is not showing up. I tried both below:gs.addErrorMessage(gs.getMessage('Duplicate ...
Hi,I'm working on a work flow for a catalog. My workflow is on 'sc_req_item' table.We have an inbound action from where some values are captured and from there is stored on a separate custom table(not in any way related to RITM table) .I want to make...
Hello, I am implementing a system based on Business Rules that use the RESTMessageV2 API to make requests to an external service. This system will be potentially doing a high number of requests. Is there any rate limit to outbound REST API requests? ...
Hi everyone. Could someone help me with an onCondition( ) script inside UI Policy? Since I cannot dot walk using the GUI to > Country Code = 'Canada'. I will need to write a script that does the following: If the country code is 'Canada', make the ...
Hello!I facing a really complex task right now, which is to migrate the entire workflow logic to flow designer.Doing this I note that for some reason, the creation of tasks for example, by Flow Designer is slowly than tasks created by the Workflow.My...
Hi Has anyone worked with flow designer to send an email notification with link to current request number? Thanks
Hello, I have a SFTP folder created where within that folder there are multiple subfolders which will contain same set of CSV files. Below is the example structure of SFTP folder considering ABC as the main SFTP folder ABC --> ABC-1 ...
Hi all,I was moving update set from Dev to Test with changed assignment rules on incident and sc_task table.Assignment rules for Incident table has been applied correctly, but rules for sc_task table not.I got a following error in commit log : "Versi...