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

Created by user-4b453 on Feb 11, 2022
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
Release
Yes/No
8.3.x(tick)
8.2.x(tick)
Applicable RDBMS
RDBMS
Yes/No
Oracle Server(tick)
Microsoft SQL Server(tick)
CSS(tick)
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