Promote

Add Structure Object Filters

Structure Object filters are added to packages to further define SQL objects being compared and transported across environments.

To add Structure Object filters to a package:

  1. Select Packages in the Navigation pane.

  2. Click the Packages icon for the package group.

  3. Click Vertical View for the package.

  4. Click the Object Structure tab.

  5. Click Edit.

    View the page description for the Packages page

  6. Select an object from the Structure Object ID list box.

  7. Enter a WHERE clause in the Structure Object Where Clause field to filter out specific SQL objects in order to add granularity to the compare process. Refer to Available Fields for WHERE Clauses for details on what fields can be used in a WHERE clause for Structure Objects.

  8. Click Save.

Available Fields for WHERE Clauses

Structure Object Name: Target

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

Structure Object Name: Target Rule

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetRuleList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

TargetRule

DSW.dbo.ttWaveProcessAreaObjectTargetRule.TargetRule

Structure Object Name: Target Reports/Remediations

List View Database: DSW

Structure Object List View: apiPromote_TargetReportAndRemediation_SQLObjects_Sel

Fields Available to Filter

Field Filter Value Format

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

TargetReport

DSW.dbo.ttWaveProcessAreaObjectTargetReport.TargetReport

Structure Object Name: Target Export

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetExportList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

TargetExport

DSW.dbo.ttWaveProcessAreaObjectTargetExport.TargetExport

Structure Object Name: Target Source

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetSourceList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

Source

DSW.dbo.ttWaveProcessAreaObjectTargetSource.Source

Structure Object Name: Target Source Rule

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetSourceRuleList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

Source

DSW.dbo.ttWaveProcessAreaObjectTargetSource.Source

SourceRule

DSW.dbo.ttWaveProcessAreaObjectTargetSourceRule.SourceRule

Structure Object Name: Target Source Report

List View Database: DSW

Structure Object List View: apiPromote_WaveProcessAreaObjectTargetSourceReportList

Fields Available to Filter

Field Filter Value Format

TargetName

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name + ' - ' + Console.dbo.ttTarget.Name

WaveProcessAreaObject

Console.dbo.ttWave.Name + ' - ' + Console.dbo.ttProcessArea.ProcessArea + ' - ' + Console.dbo.ttObject.Name

Target

Console.dbo.ttTarget.Name

Source

DSW.dbo.ttWaveProcessAreaObjectTargetSource.Source

SourceReport

DSW.dbo.ttWaveProcessAreaObjectTargetSourceReport.SourceReport

Structure Object Name: Data Source Database

List View Database: DSPCommon

Structure Object List View: apiPromote_DataSourceDatabaseSet

Fields Available to Filter

Field Filter Value Format

Name

DSPCommon.dbo.DataSourceRegistry.Name