Manual:Semantic MediaWiki/Examples/Customer 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:

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

                

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 |? we define which property values we want to display (2).

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).

	Has location	Has contact person	Has First contact
Hallo Welt GmbH	Regensburg	Jane Doe	21 December 2020
Semantic MediaWiki/Examples/Customer data/Customer page	Berlin	David Wang	18 December 2020

Adjusting the output format

The output of the data is very flexible and offers many customizing options. Let's look at some examples.

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):

Customer	Location	Contact	Date of first contact
Hallo Welt GmbH	Regensburg	Jane Doe	21 December 2020
Semantic MediaWiki/Examples/Customer data/Customer page	Berlin	David Wang	18 December 2020

Query:

                    {{#ask:
 [[Category:Customer data]]
 |?Has location = Location
 |?Has contact person = Contact
 |?Has First contact= Date of first contact
 |mainlabel = Customer
 |format= broadtable
}}

                

Simple page list

Output of pages that use the template "Customer data" in a list format:

• Hallo Welt GmbH
• Semantic MediaWiki/Examples/Customer data/Customer page

Query:

                    {{#ask:
 [[Category:Customer data]]
 |format= ul
}}

                

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:

                    {{#ask:[[Manual:+]] [[Category:Customer data]]
|?Has location = Location
}}

                

Result:

	Location
Semantic MediaWiki/Examples/Customer data/Customer page	Berlin

The following query shows all results for the namespace Manual and for the namespace (Main)and' 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 (:+).

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

                

Result:

Kunde	Location
Hallo Welt GmbH	Regensburg

The following query shows the results from namespace Manual and from the category Customer data.

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

Result:

Customer	Location
Hallo Welt GmbH	Regensburg

Related info

• https://www.semantic-mediawiki.org/wiki/Help:Inline_queries Help page for semantic inline queries