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:

Select Packages in the Navigation pane.
Click the Packages icon for the package group.
Click Vertical View for the package.
Click the Object Structure tab.
Click Edit.

View the page description for the Packages page
Select an object from the Structure Object ID list box.
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.
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