Database views is not showing records but showing the count
Database views is not showing records but showing the count. Below are the where clause i have used.
Forum Posts
Resolved! Is there a way to find out what members were removed from the group?
Is there a way to find out what members were removed from the group?
Resolved! Couldn't find the event table in a search list when create record from the flow designer
Hello Community, I have a flow in scope application and Want to fire an event for the notifications from the flow designer. When I select to create a record and in a table, I couldn't find the "sysevent" table in a search list. Is there anything I am...
Resolved! Table Name data type for ci class
Hi, I created custom table and one column in it named CI Class with type table name. Now I should select only table names which are extensions of cmdb_ci table in that column with table name type. Can someone help me how to achieve this. Thanks
Auto populate info on catalog item form
Hi, I am a newbie to catalog item form configuration and the below areas holding me to complete the form. 1. Variable set - Reporting User Email/(would like to auto populate based on reporting user name from user table) - I have given the default va...
How to investigate the use of WIDGET in the area.
In order to conduct an impact study, we are investigating where the widget is used. You can check the list of widgets from Service Portal > widgets, but where in the portal is each widget being used? Is there a way to investigate this? We think it wo...
Resolved! Approval Record - Display Value
Hi, smart folks. The Approval table, sysapproval_approver, has as it's only Display column, a document_id type field. The document_id field references another table, sc_req_item. But this has the effect of making the Approval records LOOK LIKE Reque...
Resolved! Is it possible to separate announcement widgets in the service portal?
I would like to prepare two announcement widgets on the service portal and divide the contents to be displayed according to the contents. For example, create a category field in the announcements table.Use this category field to separate announcement...
Increase Agent Presence Timeout.
Hi Everyone, Please guide on how to increase time out for agent presence .We are using advanced work assignment. Currently when agent workspace is closed and the agent is working outside of agent workspace on native platform , after 10 mits the agen...
How to export data from one instance to another EXCLUDING sys ids (target instance should generate new sys ids)?
This question is applicable for nearly any topic but, specifically, my objective is to export a select number of categories from Knowledge > Knowledge Categories from a Development instance to a Production instance. To avoid sys id conflicts, I'd pre...
Resolved! Agent workspace client script
Hi Expert , Please check the following UI Action. We know that we can write client side + Server side code in same UI action with the help of gsftSubmit() function. I want to do same for "Workspace client script" as well . so when i click button from...
Create a Metric Definition Based on RITM Variable?
I can't find much on this, but I'm wondering if it's at all possible to create a metric definition based on a specific variable. Initially, I would say "no", but looking at the metric definition form, I see the below, which makes me wonder if this is...
Resolved! Reference qualifier is blocking NULL though not specified when a condition is configured
So an odd or confusing behavior that i'd appreciate another set of eyes to concur and/or help explain the behavior: i've got a simple reference qualifier for a variable looking at the sys_user table, as part of a catalog item var set (screenshot pr...
Multiple mid Server installation on single windows machine
I have installed 4 Mid-Servers on single windows machine. But at a time only one Mid-Server for which I run start.bat comes up and the other 3 Mid-Servers services are down . In services.msc for 4 different configurations I see only one service. Wha...
User/Role specific session timeout configuration in ServiceNow
Dear Team, Is there a way can i make System Administrators or selected set of users based on roles to skip from the automatic logout/session timeout configured in system properties. System Property --> glide.ui.session_timeout Basically i want to s...
