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 |  |
| 8.2.x | |
Applicable RDBMS
RDBMS | Yes/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