View source for Template: PDMIndexQuery

==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
}}
</onlyinclude>
<noinclude>[[Category:PDMs]]</noinclude>