User:Ttenbergen/pastebin: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
(Created page with "== SMW ================================================= {{#ask: [[CommitteeMember::={{PAGENAME}}]] Category:something [[Property::something]] DICStatus::!retired V...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
== SMW =================================================
== SMW ==
<pre>
{{#ask: [[CommitteeMember::={{PAGENAME}}]] [[Category:something]] [[Property::something]] [[DICStatus::!retired]]
{{#ask: [[CommitteeMember::={{PAGENAME}}]] [[Category:something]] [[Property::something]] [[DICStatus::!retired]]
  [[VacationBackDate ::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]] [[!~Dr.*]] [[!:{{PAGENAME}}]]
  [[VacationBackDate ::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]] [[!~Dr.*]] [[!:{{PAGENAME}}]]
Line 14: Line 15:
{{#show: Berlin |?Population }}
{{#show: Berlin |?Population }}
{{#set:  Has postcode=75001 }}
{{#set:  Has postcode=75001 }}
</pre>


== Cargo =================================================
== Cargo ==
<pre>
{{#cargo_query:
{{#cargo_query:
tables=table1=tableAlias1, table2=tablesAlias2, etc.
tables=table1=tableAlias1, table2=tablesAlias2, etc.
Line 37: Line 40:
...additional format-based parameters
...additional format-based parameters
}}
}}
====== cargo category query ====
</pre>
 
=== cargo category query ===
<pre>
{{#cargo_query:
{{#cargo_query:
tables=_pageData
tables=_pageData
Line 45: Line 51:
|default=none found
|default=none found
}}
}}
</pre>

Latest revision as of 15:51, 2021 October 4

SMW

{{#ask: [[CommitteeMember::={{PAGENAME}}]] [[Category:something]] [[Property::something]] [[DICStatus::!retired]]
 [[VacationBackDate ::>{{CURRENTDAY}} {{CURRENTMONTHNAME}} {{CURRENTYEAR}}]] [[!~Dr.*]] [[!:{{PAGENAME}}]]
|default=none found
|mainlabel=- 
|sort=property-to-sort-by
|order=Ascending
|format=UL list datatable
|limit=10
|link=none
|headers=show
|sep=; }}

{{#show: Berlin |?Population }}
{{#set:  Has postcode=75001 }}

Cargo

{{#cargo_query:
tables=table1=tableAlias1, table2=tablesAlias2, etc.
|join on=table1.fieldA = table2.fieldB,table2.fieldC=table3.fieldD, etc.
|fields=sometable._pageName=fieldAlias1,field2=Alias2, workdays._pageName,
CONCAT("[[",a field that's a page, " | ", a field or text we want to show on list instead, "]]")=name, 
CONCAT("\[\{\{fullurl:",Discussions._pageName, "{{!}}action=formedit\}\} edit to add person to role]")=formedit
|where=table1.fieldE="some value" AND/OR etc. _pageID = {{PAGEID}}
|group by=table1.fieldG
|having=table1.fieldG='some value', etc.
|order by=table2.fieldF, etc.
|limit=1000
|default=no results were found
|more results text=some text
|offset=some number
|intro=<b>some text</b>
|outro=some text
|no html
|max display chars=some number
|format=dynamic table ul list
...additional format-based parameters
}}

cargo category query

{{#cargo_query:
tables=_pageData
|fields=_pageName
|where=_categories HOLDS 'Section' and _pageName!="N/A" and not _pageName Like "Category:%"
|limit=5000
|default=none found
}}