Resolved! How to join multiple tables?
How to join multiple tables in ServiceNow? <Sample SQL> SELECT TABLE_1.AAA, TABLE_1.BBB, TABLE_2.CCC FROM FROM TABLE_1 INNER JOIN TABLE_2 ON TABLE_1.DDD = TABLE_2.DDD WHERE TABLE_1.EEE IS NULL
How to join multiple tables in ServiceNow? <Sample SQL> SELECT TABLE_1.AAA, TABLE_1.BBB, TABLE_2.CCC FROM FROM TABLE_1 INNER JOIN TABLE_2 ON TABLE_1.DDD = TABLE_2.DDD WHERE TABLE_1.EEE IS NULL
I've been working on a couple of applications in dev and having been publishing versions, the versions become available on our test and prod instances which is all normal.However we had to clone Prod over Dev for another app to be started, as we need...
Hello all, I am new to service now. I created an app by importing from my github account. Then I deleted it and started creating another app using the same details. However I am getting the error "Another application is already associated with the sp...
I have tried to create a protocol (xssl) to use my COMODO client certificate (I have tried to use it using .pfx, cer, and JavaKeyStore file formats.In each case, when I enable mutual authentication, I get an error 500, and a log saying:SOAP Msg Outbo...
Hello Community, I am trying to modify the My Request button located in the header to show the list of all tickets open by the user (Incidents and Request) with a filter to select only closed or open tickets. I tried to clone the My_request page ...
We are using Agile 2.0 and Test Management 2.0. When you access the Sprint Tracking tab on the Agile Board, you can add Tests to Stories. However, on the Test record itself, there is no field tying the Test to the Story. I would expect a reference f...
Hi, I want to display an info message in multi line. How can I do that. I tried inserting "\n" in the string but it is not going to next line. How can do that?
Hi, I got below requirement, please let me know if anyone has implemented it before: 1. Display a message to all users in their local language post login to Servicenow Instance . 2. This message should only be displayed once per session and not every...
Good morning developers, I need a little help. I was tasked with creating a button on our Service Portal for Closed Tickets. This button will be called Reoccurrence. The functionality is for the user to be able to go to a closed ticket from the Ticke...
Hi Community, I have an integration currently in place and have attachments for incidents being sent within a 1 minute expiry when the attachment is on the attachment table for over 1 minute the attachment is not included when the ticket is sent over...
Hi, when an incident state is closed active=true not false and when I want to change active to false manually there are some incidents active change to false but some incident active remains true . how I can solve this problem once the inicdent is ...
POST/PUT request from ServiceNow to third party REST API.
I am using ServiceNow REST API calls to show SN records inside my application. My application takes username,password and domain from the user to do this. I have this situation where one of my client uses OneIdentity SSO for their servicenow applicat...
Hi guys,I've a 'generated_new_unsigned.pdf' file which is attached to sys_user table (for test),Also I've a signature (activated through Signature Pad plugin) with the following sys_id: 8fa2a193db8003006b2e7b1ebf9619c6Now I want to add mentioned sign...
Hello Team && @Ankur Bawiskar ., We face a problem on restAPI. Suddenly the request from application XYZ to ServiceNow API in lower environment return error400 bad request. But via postman i get 200 OK result. Operation: HTTP GET https://<InstanceUR...
