SQL Queries - CAST Management Base - How to set the Database Subset to inactive in CAST-MS

Purpose of Query

This page explains how to set the Database Subset to inactive in the Module option in CAST MS through a query.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS✅

Query

1- In Management Database run the following :

UPDATE cms_dynamicfields cdf 
SET    field_value = 'DBSubsetTypeInactive' 
WHERE  cdf.entity_guid = 'pmcportfolio.Application' 
       AND cdf.field_guid = 'dbSubsetStrategy';

Query result example

Number of rows updated

Query result interpretation

No further interpretation required

Related Pages