When creating a database view it is sometimes necessary to join tables via a Document ID type field. Like Reference fields, Document ID fields allow the record to reference another record.

This article will explain the use of the 'Where clause' in a database view and how to apply a filter on the data. Use of the 'Where clause' The 'Where clause' in a database view is primarily used …

To access the records in the performance analytics (Analytics hub) , users should have access to the tables which are applied on the indicators and also to the database view if any existed on …

However, when following the steps in KB0535471 (looking at the ACLs which are being evaluated as part of the database view by Configure > Security Rules from the database view record …

この記事では、データベースビューでの「WHERE 節」の使用と、データにフィルターを適用する方法について説明します。 「WHERE 節」の使用 データベースビューの「WHERE 節」 …

To change a label for a column in a report only, without changing the label for the underlying table in the system dictionary, create a custom database view to use as the report source and …

Unable to find records of Database Views as Service Catalog variables. Steps to Reproduce: Log into the instance. Check on the Database Views below: …

Unable to add Variables to a report if it is a dot-walked field. Steps to Reproduce Create a report on the sc_task table or database view sc_task_sla. From the Available list, find Request Item …

There is a Database view, which is a join of these two view tables: [sn_communities_idea] and [sn_communities_content]. A calculated type field on [sn_communities_idea] does not display …

Customers often inquire, if they can show the variables of a Requested Item in the list view. Unfortunately, it is currently not possible to include the Variable Editor or any UI Formatter in a …