User:Ttenbergen/pastebin: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) (Created page with "== SMW ================================================= {{#ask: [[CommitteeMember::={{PAGENAME}}]] Category:something [[Property::something]] DICStatus::!retired V...") |
Ttenbergen (talk | contribs) |
||
(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 | ||
}} | }} | ||
</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 }}