TestPDMIndexQueryFormat

Formatting template used by Template:TestPDMIndexQuery to format the individual tables for each index on table pages. This template parallels Template:TestPDMIndexItem.dpl2, which used to be used for the equivalent DPL query.

{{AnchorDiv|{{{anchor}}}}}
===Index {{{indexName}}}===
{{#switch:{{lc:{{{indexPresentInPartitioned}}}}}
|n
|no=This index is present only in nonpartitioned databases.
|y
|yes
|#default=}}
{{{!}}
! '''Field'''
! '''Sort'''
! '''Comment'''
{{#if:{{{indexKey|}}}|
{{!}}-
{{!}} {{{indexKey}}}
{{!}} {{{sort}}}|
{{!}}-
{{!}} {{{indexKey1}}}
{{!}} {{{sort1}}}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned1}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey2|}}}|
{{!}}-
{{!}} {{{indexKey2}}}
{{!}} {{{sort2}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned2}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey3|}}}|
{{!}}-
{{!}}{{{indexKey3}}}
{{!}} {{{sort3}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned3}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey4|}}}|
{{!}}-
{{!}} {{{indexKey4}}}
{{!}} {{{sort4}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned4}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey5|}}}|
{{!}}-
{{!}} {{{indexKey5}}}
{{!}} {{{sort5}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned5}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey6|}}}|
{{!}}-
{{!}}{{{indexKey6}}}
{{!}} {{{sort6}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned6}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey7|}}}|
{{!}}-
{{!}}{{{indexKey7}}}
{{!}} {{{sort7}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned7}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey8|}}}|
{{!}}-
{{!}}{{{indexKey8}}}
{{!}} {{{sort8}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned8}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra=This field is present only in partitioned databases.
|PDMPostgre
|GIMRef
|RPRT=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey9|}}}|
{{!}}-
{{!}}{{{indexKey9}}}
{{!}} {{{sort9}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned9}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}
{{#if:{{{indexKey10|}}}|
{{!}}-
{{!}}{{{indexKey10}}}
{{!}} {{{sort10}}}
{{!}} {{#switch:{{lc:{{{keyPresentInNonpartitioned10}}}}}
|n
|no={{#switch:{{#explode:{{{page}}}|:|2}}
|PDMMS
|PDMOra
|GIMRef
|RPRT=This field is present only in partitioned databases.
|PDMPostgre=This field is not included in this index in PostgreSQL.
|Library='''In the MSSQL and Oracle PDMs:''' This field is present only in partitioned databases.<br>
'''In the Postgre PDM:''' This field is not included in this index in PostgreSQL.}}
|y
|yes
|#default=}}|}}|}}|}}|}}|}}|}}|}}|}}|}}
{{!}}}

Index {{{indexName}}}

Field	Sort	Comment
{{{indexKey1}}}	{{{sort1}}}