table:database-range

Element information

Namespace: urn:oasis:names:tc:opendocument:xmlns:table:1.0

Schema document: table.xsd

Type: Anonymous

Properties: Global, Qualified

Content

Sequence [1..1]
1. Choice [0..1]
2. table:filter [0..1]
3. table:sort [0..1]
4. table:subtotal-rules [0..1]

Attributes

Name	Occ	Type	Notes
table:name	[1..1]	text:string	from group table:name
table:is-selection	[0..1]	text:boolean	Default value is "false". from group text:table-database-range-attlist
table:on-update-keep-styles	[0..1]	text:boolean	Default value is "false". from group text:table-database-range-attlist
table:on-update-keep-size	[0..1]	text:boolean	Default value is "true". from group text:table-database-range-attlist
table:has-persistent-data	[0..1]	text:boolean	Default value is "true". from group text:table-database-range-attlist
table:orientation	[1..1]	Anonymous	from group table:orientation
table:contains-header	[0..1]	text:boolean	Default value is "true". from group text:table-database-range-attlist
table:display-filter-buttons	[0..1]	text:boolean	Default value is "false". from group text:table-database-range-attlist
table:target-range-address	[1..1]	text:cellRangeAddress	from group text:table-database-range-attlist
table:refresh-delay	[1..1]	text:boolean	from group table:refresh-delay1

Used in

Anonymous type of element table:database-ranges

Sample instance

<table:database-range table:name="string" table:orientation="column" table:target-range-address="string" table:refresh-delay="true">
   <table:database-source-sql table:database-name="string" table:sql-statement="string"/>
   <table:filter>
      <table:filter-condition table:field-number="1" table:value="string" table:operator="string" table:case-sensitive="string" table:data-type="text"/>
   </table:filter>
   <table:sort table:case-sensitive="true">
      <table:sort-by table:field-number="1" table:data-type="text"/>
   </table:sort>
   <table:subtotal-rules table:case-sensitive="true">
      <table:sort-groups table:data-type="text"/>
      <table:subtotal-rule table:group-by-field-number="1">
         <table:subtotal-field table:field-number="1" table:function="auto"/>
      </table:subtotal-rule>
   </table:subtotal-rules>
</table:database-range>