View source for Manual:Semantic MediaWiki/Examples/Customer data/Queries

{{DISPLAYTITLE:Semantic data queries}}

You can query and display the data that you collect in the wiki at at any time on any wiki page. 

=="Ask" queries==
With the parser function "#ask", we can now use the semantic properties and the category association to show the collected data on our wiki pages.

As an example, we list the pages that collect customer data. You can include this  "ask" query on any wiki page:<syntaxhighlight lang="text">
{{#ask:
 [[Category:Customer data]]
 |?Has location 
 |?Has contact person
 |?Has First contact
}}
</syntaxhighlight>
This query first defines via the category ''Customer data'' that only  pages within this category should be included in the data query (1). 

Then, using the pipe-syntax  <code>|?</code>  we define which property values we want to display (2).
<br />

[[File:Manual:ask-Abfrage-einfach-EN.png|alt=Simple "ask" query|center|thumb|300x300px|Simple "ask" query]]


The default results output is in a table format. The page from which  the customer data originates is automatically added as a first column (this can be customized as needed).

<br />

{{#ask:
 [[Category:Customer data]]
 |?Has location 
 |?Has contact person
 |?Has First contact
}}

==Adjusting the output format==
The output of the data is very flexible and offers many customizing options. Let's look at some examples.
<br />

===Table formatting===

Output with adjusted table width of 100%  (format=broadtable) and with adjusted column labels. The first column also gets a custom label (mainlabel=Customer):

{{#ask:
 [[Category:Customer data]]
 |?Has location = Location
 |?Has contact person = Contact
 |?Has First contact= Date of first contact
 |mainlabel = Customer
 |format= broadtable
}}Query:<syntaxhighlight lang="text">
{{#ask:
 [[Category:Customer data]]
 |?Has location = Location
 |?Has contact person = Contact
 |?Has First contact= Date of first contact
 |mainlabel = Customer
 |format= broadtable
}}

</syntaxhighlight>
===Simple page list===

Output of pages that use the template "Customer data" in a list format:
{{#ask:
 [[Category:Customer data]]
 |format= ul
}}
Query:<syntaxhighlight lang="text">
{{#ask:
 [[Category:Customer data]]
 |format= ul
}}

</syntaxhighlight>

==Adjusting the query==
In semantic queries, results can be filtered by namespaces, categories and semantic attributes.

===Examples===
The following query shows all results for the namespace ''Manual'' and the category ''Customer data''. The output shows the location of the customers:
<syntaxhighlight lang="text">
{{#ask:[[Manual:+]] [[Category:Customer data]]
|?Has location = Location
}}
</syntaxhighlight>

Result:
{{#ask:[[Manual:+]] [[Category:Customer data]]
|?Has location = Location
}}
<br />The following query shows all results for the namespace ''Manual'' '''and'' for the namespace ''(Main)'''''and'<nowiki/>'' for the category ''customer data''. All three selection criteria have to be valid for a page to be included in the results. (Note: The namespace (Main) is referenced as empty prefix (<code>:+</code>).<syntaxhighlight lang="text">
{{#ask:[[Manual:+||:+]] [[Category:Customer data]]
|?Has location = Location
|mainlabel = Customer
}}
</syntaxhighlight>

Result:
{{#ask:[[Handbuch:+||:+]] [[Category:Customer data]]
|?Hat Standort = Standort
|mainlabel = Kunde
}}
The following query shows the results from namespace ''Manual'' and from the category ''Customer data''.
<syntaxhighlight>
{{#ask:[[Category:Customer data]] [[Has location::Regensburg]]
|?Has location = Location
|mainlabel = Customer
}}
</syntaxhighlight>

Result:
{{#ask:[[Category:Customer data]] [[Has location::Regensburg]]
|?Has location = Location
|mainlabel = Customer
}}


{{Box Links-en|Topic1=[https://www.semantic-mediawiki.org/wiki/Help:Inline_queries https://www.semantic-mediawiki.org/wiki/Help:Inline_queries] Help page for semantic inline queries}}