Ontoprise: auto-generated by Wiki admin tool

2011-11-25T14:06:43Z

auto-generated by Wiki admin tool

New page

{| align="center" cellspacing="2" width="100%"
|-
| align="left" | <div style="font-size: 20pt; line-height: 30px">The QueryInterface Learn to query for data </div>
| align="left" | [[File:QI_head.png|300px|QueryInterface]]
| align="right" | __TOC__
|} __NOTOC__
Fred always has much work to do and finds it very handy to overview his tasks in well-arranged tables. For this, he wants to create a table that not only contains all relevant information, but also gets automatically updated everytime something has changed or was created. You can help him to create the table by using one of SMW+/Halo's basic features: the [[Glossary#query|Query Interface]].

= Open the QueryInterface =
#Select from the '''Articles and data'''-menu the menu item '''QueryInterface'''
#:[[File:Queryinterface_menu.png|thumb|left|500px|Click on the "QueryInterface" menu item to open the QueryInterface.]]
#The QueryInterface opens.
#:[[File:TUT firstannotation10.png|thumb|left|550px|The Query Interface special page.]]

'''Result: the QueryInterface is open and you can start building your query.'''

= Build the query =
#Click '''Add category'''. Like in the Data Toolbar you can press {{Keys|Ctrl}} + {{Keys|Alt}} + {{Keys|Space}} to use autocompletion.
#Enter <tt>Smwplussandbox/Task</tt>
#Click '''Add'''.
#Below the section '''Result preview''' you should now see all articles ("[[Glossary#instance|instances]]") that contain the category tag "Smwplussandbox/Task". You will also notice your new task "Update screenshots":
#:[[File:TUT firstannotation11.png|thumb|left|400px|The list of query results is located in the "Result preview" section.]]
#In order to restrict the results to Freds tasks, you click on '''Add property'''
#Enter <tt>Smwplussandbox/Assigned to</tt>
#Activate the checkbox '''Show in results''' to list the property values in the result preview
#Activate the checkbox '''Value must be set''' to get only results that have explicitly this property
#Activate the radiobutton '''Specific value'''
#Enter <tt>User:Fred</tt> in the field '''property value'''
#Click '''Add'''. Your screen should look similar to this:
#:[[File:TUT firstannotation12.png|thumb|left|550px|Restrict the values of query results.]]
#Open again the '''Result preview''' to verify that it contains only tasks that belong to Fred.

'''Result: You have created a query for all tasks that belong to a Fred.'''

You can add more properties (e.g. End date, description...) if you like and do this via trial and error in the Query Interface until you are satisfied with the results. And if you have the [http://smwforum.ontoprise.com/smwforum/index.php/Help:Semantic_Result_Formats Semantic Result Formats extension] installed, you can also use timelines, 3d-bars, pie-charts, maps etc. to visualize the data.

{{NoteInText|If you call the QueryInterface from within the WYSIWYG editor then you can embed the result table into the article.}}

= Embed a query into an article =
#Open the article that you have created in [[Smwplussandbox/Create_articles|Lesson 1: Create articles]].
#Open the article in the WYSIWYG editor by clicking on the "Edit"-tab.
#:[[File:Edittab.png|thumb|left|250px]]
#Place the cursor somewhere in the text of the article.
#Click on the "Query Interface" icon to open the Query Interface.
#:[[File:WWqueryinterface.png|thumb|left|500px]]
#The Query Interface must be visible as an overlay in the WYSIWYG editor.
#:[[File:TUT firstannotation10.png|thumb|left|550px]]
#Click '''Add category'''. Like in the Semantic Toolbar you can press {{Keys|Ctrl}} + {{Keys|Alt}} + {{Keys|Space}} to use autocompletion.
#Enter <tt>Smwplussandbox/Task</tt>
#Click '''Add'''.
#Below the section '''Result preview''' you should now see all articles ("[[Glossary#instance|instances]]") that are assigned to the category "Task". You will also notice your new task "Update screenshots":
#:[[File:TUT firstannotation11.png|thumb|left|400px]]
#Click on the button "Insert Query" (located at the bottom of the overlay) to embed the query result into the article.

'''Result: the query result is embedded into your article.'''

= Next Lesson =

{| align="center" cellspacing="2" width="90%"
|-
! width="50%" | 
! width="10%" | 
! width="40%" | 
|-
| Tried out enough? Then it's time to go to the next sandbox: '''Create your own data model with the DataExplorer''' 
| 
| [[File:Button GoToNext.png|left|Button GoToNext.png|link=Smwplussandbox/Create_a_data_model]]
|}

 [[Rationale::This article is the second sandbox of the SMW+ sandbox tour. It gives some basic hints to the Query Interface, provides demo content elements and an area where users can check out the editor and play with the content elements.| ]] [[Part of bundle::Smwplussandbox]]

Smwplussandbox/Query for data - Revision history

Ontoprise: auto-generated by Wiki admin tool