Developer forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Complex database view

I have for 4 tables in ServiceNowcert_auditcert_audit_resultu_worklog (Custom table)u_m2m_worklogs_configuration (M2M table from cmdb_ci to u_worklog)In SQL I would have created bellow kind of a query as a view to be used by users SELECT car.configur...

How to attach .ics file in notification

Hi all,There is one notification triggering to the assignment group after submitting the catalog item.Within that notification we need to attach a .ics file that will leave a placeholder into group people agenda.Could you suggest how to achieve this?

Resolved! How can we create a new source table of Transform map

I need to import choices of a variable so first I need to create a source table so that table I am able to select in transform map's "Source table field" so how can we create new source table any idea? please find the attached snapshot.

pwr227 by Tera Contributor
  • 1950 Views
  • 3 replies
  • 3 helpfuls

Auto update state in case

Hi Developers, Just need help in 2 scenarios of in case mangement. Case state needs to be automatically updated to inprogress when case reaches 'on hold until ' date from onhold and case state should automatically change to responded when user respon...

Admin account need to veify

Hi Connection There is an account in ServiceNow with UserID:  SN_PRD_admin Is there a way you can check if this account is used somehow?last login is in 2017 Best Regards,Rafmine

Community Alums by Community Alums  
  • 195 Views
  • 3 replies
  • 0 helpfuls

Resolved! Querying To Get Two Values from Same Table and Divide and Get Percentage

Hi There, Greetings!!! I have a requirement to Get two values from same table and divide and get percentage in a Service Portal: I am trying to calculate total number of courses assigned to divide by completed courses. In below code firstly, I am fet...

Tejas12_0-1703834735725.png
Community Alums by Community Alums  
  • 418 Views
  • 7 replies
  • 0 helpfuls

How to Update Business Application form by using catalog item

Hello Experts, In business application (cmdb_ci_business_app) form having 20+ attributes. Same attributes I have created in catalog item.(to reduce ITIL role usage).  Workflow of this catalog item I want to send approvals with below conditions Approv...

Nani18 by Tera Contributor
  • 644 Views
  • 7 replies
  • 0 helpfuls

Show matching cant find a value even though its populated

Hi,I have the custom field u_nickname which is a calculated field according to some script on the sys_user table.When I click show matching, even though there is a value inside the field it shows that it cant find it. Any idea why? After clicking Sho...

WhatsApp Image 2024-01-02 at 11.00.53.jpeg WhatsApp Image 2024-01-02 at 11.00.55.jpeg
Alon Grod by Tera Expert
  • 442 Views
  • 3 replies
  • 0 helpfuls