table:database-ranges

Element information

Content

• table:database-range [0..*]    

Attributes

None

Used in

• Group text:table-functions
• Anonymous type of element office:chart via reference to text:office-chart-content-epilogue
• Anonymous type of element office:drawing via reference to text:office-drawing-content-epilogue
• Anonymous type of element office:presentation via reference to text:office-presentation-content-epilogue
• Anonymous type of element office:spreadsheet via reference to text:office-spreadsheet-content-epilogue
• Anonymous type of element office:text via reference to text:office-text-content-epilogue
• Group text:office-chart-content-epilogue via reference to text:table-functions
• Group text:office-drawing-content-epilogue via reference to text:table-functions
• Group text:office-presentation-content-epilogue via reference to text:table-functions
• Group text:office-spreadsheet-content-epilogue via reference to text:table-functions
• Group text:office-text-content-epilogue via reference to text:table-functions

Sample instance

<table:database-ranges>
   <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-rule>
      </table:subtotal-rules>
   </table:database-range>
</table:database-ranges>