element <etl:deletedRowsSource>
Namespace:
http://labkey.org/etl/xml
Type:
etl:DeletedRowsSourceObjectType
Content:
complex, 11 attributes, 2 elements
Defined:
locally within complexType etl:FilterType in etl.xsd, see XML source
XML Representation Summary
<etl:deletedRowsSource
    containerFilter
 = 
 ("Current" | "CurrentWithUser" | "CurrentAndFirstChildren" | "CurrentAndSubfolders" | "CurrentAndSiblings" | "CurrentOrParentAndWorkbooks" | "CurrentPlusProject" | "CurrentAndParents" | "CurrentPlusProjectAndShared" | "AssayLocation" | "WorkbookAndParent" | "StudyAndSourceStudy" | "AllFolders")
    deletedSourceKeyColumnName
 = 
 string
    queryName
 = 
 string
    remoteSource
 = 
 string
    runColumnName
 = 
 string
    schemaName
 = 
 string
    sourceContainerPath
 = 
 string
    sourceTimeout
 = 
 integer
    targetKeyColumnName
 = 
 string
    timestampColumnName
 = 
 string
    useTransaction
 = 
 boolean : "true"
    >
   
Content: 
 etl:sourceColumns? × etl:sourceFilters?
</etl:deletedRowsSource>
Content model elements (2):
etl:sourceColumns (type etl:SourceColumnsType),
etl:sourceFilters (type etl:SourceFiltersType)
Included in content model of elements (1):
etl:incrementalFilter (in etl:etl)
Definition Locations
Annotation
Defines a query with a list of rows to delete from the target in this incremental run.<br/> Timestamp or run filter values against the delete rows source are tracked independently from the values in the<br/> original source query. I.e., there could be no new records in the source query, but new records in the delete rows source<br/> will still be found and deleted from the target.
XML Source (see within schema source)
<element minOccurs="0" name="deletedRowsSource" type="etl:DeletedRowsSourceObjectType">
<annotation>
<documentation>
Defines a query with a list of rows to delete from the target in this incremental run.&lt;br/&gt;
Timestamp or run filter values against the delete rows source are tracked independently from the values in the&lt;br/&gt;
original source query. I.e., there could be no new records in the source query, but new records in the delete rows source&lt;br/&gt;
will still be found and deleted from the target.
</documentation>
</annotation>
</element>
Attribute Detail
containerFilter
Type:
cv:containerFilterType
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
Specify the type of container filter to use on the source query.
XML Source (see within schema source)
<attribute name="containerFilter" type="cv:containerFilterType" use="optional">
<annotation>
<documentation>
Specify the type of container filter to use on the source query.
</documentation>
</annotation>
</attribute>
deletedSourceKeyColumnName
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:DeletedRowsSourceObjectType complexType
The column in the deletedRowsSource which holds the key values to delete in the target. If not specified, the PK values of the delete query is used.
XML Source (see within schema source)
<attribute name="deletedSourceKeyColumnName" type="string" use="optional">
<annotation>
<documentation>
The column in the deletedRowsSource which holds the key values to delete in the target. If not specified, the PK values of the delete query is used.
</documentation>
</annotation>
</attribute>
queryName
Type:
string, predefined
Use:
required
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<attribute name="queryName" type="string" use="required"/>
remoteSource
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<attribute name="remoteSource" type="string" use="optional"/>
runColumnName
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
Override the column name set on a RunFilter incremental filter.
XML Source (see within schema source)
<attribute name="runColumnName" type="string" use="optional">
<annotation>
<documentation>
Override the column name set on a RunFilter incremental filter.
</documentation>
</annotation>
</attribute>
schemaName
Type:
string, predefined
Use:
required
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<attribute name="schemaName" type="string" use="required"/>
sourceContainerPath
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
Container path for doing cross-container ETLs. If not entered, defaults to the container where the ETL is running.
XML Source (see within schema source)
<attribute name="sourceContainerPath" type="string" use="optional">
<annotation>
<documentation>
Container path for doing cross-container ETLs. If not entered, defaults to the container where the ETL is running.
</documentation>
</annotation>
</attribute>
sourceTimeout
Type:
integer, predefined
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<attribute name="sourceTimeout" type="integer" use="optional"/>
targetKeyColumnName
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:DeletedRowsSourceObjectType complexType
The column in the target query corresponding to the deleted key values. If not specified, we assume the PK of the target query.<br/> If a non-PK column is specified, the delete values will be used as lookups to map back to the corresponding PK values in the target.
XML Source (see within schema source)
<attribute name="targetKeyColumnName" type="string" use="optional">
<annotation>
<documentation>
The column in the target query corresponding to the deleted key values. If not specified, we assume the PK of the target query.&lt;br/&gt;
If a non-PK column is specified, the delete values will be used as lookups to map back to the corresponding PK values in the target.
</documentation>
</annotation>
</attribute>
timestampColumnName
Type:
string, predefined
Use:
optional
Defined:
locally, within etl:SourceObjectType complexType
Override the column name set on a ModifiedSinceFilter incremental filter.
XML Source (see within schema source)
<attribute name="timestampColumnName" type="string" use="optional">
<annotation>
<documentation>
Override the column name set on a ModifiedSinceFilter incremental filter.
</documentation>
</annotation>
</attribute>
useTransaction
Type:
boolean, predefined
Use:
optional
Default:
"true"
Defined:
locally, within etl:SourceObjectType complexType
Wrap selecting from source query in a transaction. Only used for simple query transform types.
XML Source (see within schema source)
<attribute default="true" name="useTransaction" type="boolean" use="optional">
<annotation>
<documentation>
Wrap selecting from source query in a transaction. Only used for simple query transform types.
</documentation>
</annotation>
</attribute>
Content Element Detail
etl:sourceColumns
Type:
etl:SourceColumnsType, complex content
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<element maxOccurs="1" minOccurs="0" name="sourceColumns" type="etl:SourceColumnsType"/>
etl:sourceFilters
Type:
etl:SourceFiltersType, complex content
Defined:
locally, within etl:SourceObjectType complexType
XML Source (see within schema source)
<element maxOccurs="1" minOccurs="0" name="sourceFilters" type="etl:SourceFiltersType"/>
This XML schema documentation has been generated with DocFlex/XML RE 1.7.2 using DocFlex/XML XSDDoc 2.1.0 template set.
DocFlex/XML RE is a reduced edition of DocFlex/XML, which is a tool for programming and running highly sophisticated documentation and reports generators by the data obtained from any kind of XML files. The actual doc-generators are implemented in the form of special templates that are designed visually using a high quality Template Designer GUI basing on the XML schema (or DTD) files describing the data source XML.
DocFlex/XML XSDDoc is a commercial template application of DocFlex/XML that implements a high-end XML Schema documentation generator with simultaneous support of framed multi-file HTML, single-file HTML and RTF output formats. (More formats are planned in the future).
A commercial license for "DocFlex/XML XSDDoc" will allow you:
  • To configure the generated documentation so much as you want. Thanks to our template technology, it was possible to support more than 300 template parameters (working the same as "options" of an ordinary doc-gen), which will give you an unprecedented control over the generated content!
  • To use certain features disabled in the free mode (such as the full documenting of substitution groups).
  • To enable/disable documenting of the initial, imported, included and redefined XML schemas selectively.
  • To document local element components both globally and locally (similar to attributes).
  • To enable/disable reproducing of namespace prefixes.
  • To format your annotations with XHTML tags and reproduce that formatting both in HTML and RTF output.
  • To insert images in your annotations using XHTML <img> tags (supported both in HTML and RTF output).
  • To use PlainDoc.tpl main template to generate all the XML schema documentation in the form of a single HTML file.
  • To use the same template to generate the incredible quality RTF documentation.
  • To document only selected XML schema components specified by name.
  • To remove this very advertisement text
Once having only such a license, you will be able to run the fully-featured XML schema documentation generator both with DocFlex/XML SDK and with DocFlex/XML RE, which is a reduced free edition containing only the template interpretor / output generator. No other licenses will be required!
But this is not all. In addition to it, a commercial license for DocFlex/XML SDK will allow you to modify the XSDDoc templates themselves as much as you want. You will be able to achieve whatever was impossible to do with the template parameters only. And, of course, you could develop any template applications by your own!
Please note: By purchasing a license for this software, you not only acquire a useful tool, you will also make an important investment in its future development, the result of which you could enjoy later by yourself. Every single your purchase matters and makes a difference for us!
To buy a license, please follow this link: http://www.filigris.com/shop/