Template: PDMIndexQuery

From Genesys Documentation
Jump to: navigation, search

This template providies the Cargo queries to construct the table of indexes and the individual tables for each index on the table page. The second query uses the formatting template Template:PDMIndexQueryFormat to format the output.

This template is called by Template:PDMTable (for Library book pages) and Template:PDMTablePageFormat (for RDBMS-specific pages).

This template has been modified from the one originally developed for Ponydocs, since it no longer needs to cover alternative formatting for ICON.

The |where condition in the queries replicates the condition in Template:PDMColumnQuery.

Content is:

{{#css: td.field_U {text-align: center} td.field_C {text-align: center} }}
{{AnchorDiv|IndexList}}
==Index List==
{{#cargo_query:
tables=PDMIndexItem
|fields=CONCAT('[[{{{page}}}#Index_',indexName,'|',indexName,']]')=CODE,IF(LCASE(isUnique)='yes','X','')=U,IF(LCASE(cluster)='yes','X','')=C,indexDesc=Description
|where=_pageName LIKE "{{#switch:{{MINTYDOCSVERSION}}|Library={{FULLPAGENAME}}|Current|#default={{#explode:{{FULLPAGENAME}}|/|0}}/Library/PDMLibrary{{#sub:{{#explode:{{anchorencode:{{#explode:{{FULLPAGENAME}}|/|2}}}}|_|0}}|5|3}}/{{#explode:{{FULLPAGENAME}}|/|3}}}}"
|format=table
|order by=_rowID
|default=No indexes are defined.
|named args=yes
}}
{{#cargo_query:
tables=PDMIndexItem
|fields=CONCAT('Index_',indexName)=anchor,indexName=indexName,indexDesc=indexDesc,indexPresentInPartitioned=indexPresentInPartitioned,indexKey=indexKey,indexKey1=indexKey1,indexKey2=indexKey2,indexKey3=indexKey3,indexKey4=indexKey4,indexKey5=indexKey5,indexKey6=indexKey6,indexKey7=indexKey7,indexKey8=indexKey8,indexKey9=indexKey9,indexKey10=indexKey10,keyPresentInNonpartitioned=keyPresentInNonpartitioned,keyPresentInNonpartitioned1=keyPresentInNonpartitioned1,keyPresentInNonpartitioned2=keyPresentInNonpartitioned2,keyPresentInNonpartitioned3=keyPresentInNonpartitioned3,keyPresentInNonpartitioned4=keyPresentInNonpartitioned4,keyPresentInNonpartitioned5=keyPresentInNonpartitioned5,keyPresentInNonpartitioned6=keyPresentInNonpartitioned6,keyPresentInNonpartitioned7=keyPresentInNonpartitioned7,keyPresentInNonpartitioned8=keyPresentInNonpartitioned8,keyPresentInNonpartitioned9=keyPresentInNonpartitioned9,keyPresentInNonpartitioned10=keyPresentInNonpartitioned10,sort=sort,sort1=sort1,sort2=sort2,sort3=sort3,sort4=sort4,sort5=sort5,sort6=sort6,sort7=sort7,sort8=sort8,sort9=sort9,sort10=sort10
|where=_pageName LIKE "{{#switch:{{MINTYDOCSVERSION}}|Library={{FULLPAGENAME}}|Current|#default={{#explode:{{FULLPAGENAME}}|/|0}}/Library/PDMLibrary{{#sub:{{#explode:{{anchorencode:{{#explode:{{FULLPAGENAME}}|/|2}}}}|_|0}}|5|3}}/{{#explode:{{FULLPAGENAME}}|/|3}}}}"
|format=template
|template=PDMIndexQueryFormat
|order by=_rowID
|default=
|named args=yes
}}



Index List[edit source]

No indexes are defined.

Retrieved from "https://all.docs.genesys.com/Template:PDMIndexQuery (2022-08-14 21:46:40)"