SQL Queries - CAST Central Base - SQL Queries on Objects

Purpose

This page lists the sql queries on Objects.

Details

Select the page you are interested with:
If you do not find the information you are looking for or solution for your problem, please contact CAST Technical Support

Notes / Comments

Related Pages

SQL Queries - CAST Central Base - Queries on Objects - How to get the number of object type per subset per module and per technology in the application for all snapshots

SQL Queries - CAST Central Base - Queries on Objects - How to get the object status

SQL Queries - CAST Central Base - Queries on Objects - How to count the total number of objects

SQL Queries - CAST Central Base - Queries on Objects - How to count of objects with the status added by snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to count of objects with the status deleted by snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the ID of an object

SQL Queries - CAST Central Base - Queries on Objects - How to count the objects per snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to count the number of added deleted and modified objects betweeen two snapshots

SQL Queries - CAST Central Base - Queries on Objects - How to get the delta of objects between two snapshots

SQL Queries - CAST Central Base - Queries on Objects - How to check if the objects present in the previous snapshot but not current snapshot are part of one of the Transactions in previous snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to check if the deleted technical objects has the Deleted status

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects that are part of two snapshots but they are linked only to transactions of the previous snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects that are part of the action plan for a given snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to check if an object is violated by a quality rule

SQL Queries - CAST Central Base - Queries on Objects - How to get the number of added objects in the action plan since a particular snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to change the object status to unchanged

SQL Queries - CAST Central Base - Queries on Objects - How to check if an object is modified between two snapshots

SQL Queries - CAST Central Base - Queries on Objects - How to check if an object is modified between two snapshots due to analyzer

SQL Queries - CAST Central Base - Queries on Objects - How to check if objects are shared among modules

SQL Queries - CAST Central Base - Queries on Objects - How to get the checksum of an object in a given snapshot based on its full name

SQL Queries - CAST Central Base - Queries on objects - How to get the Checksum value of an object

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of modified objects between two snapshots

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects contributing to the ADDED automated enhancement technical point for a snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects contributing to the DELETED automated enhancement technical point for a snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects contributing to the MODIFIED automated enhancement technical point for a snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects in exclusion

SQL Queries - CAST Central Base - Queries on Objects - How to get the list of objects that are part of two snapshots when the objects are linked only to transactions of the current snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the LoC associated with an object in a specific snapshot

SQL Queries - CAST Central Base - Queries on Objects - How to get the LoC by object type