Semantic MediaWiki

On Sun, May 14, 2006 at 02:19:31PM +0200, Markus Kr?tzsch wrote:
> just so you know what to do with inline queries, here comes a very brief=
=20
> collection of examples.=20

This is great, and even better than I had hoped!


> In addition, one can explicitly modify the formatting of the output by gi=
ving=20
> parameters to <ask>.=20

The comments in the code imply that I should be able to supply a 'sort'
parameter, but I can't work out how to do this.

So, for example, at http://bible.tmtm.com/wiki/King_of_Judah
I have the query:

  <ask format=3D"table" sort=3D"rule start" order=3D"desc">
   [[ruler of::Judah]] [[rule start:=3D*]] [[rule end:=3D*]]
  </ask>

But the results are sorted by the king's name, rather than the start
date. I've tried a variety of combinations, including the column
position number etc., but can't work out how to make this work.=20

Thanks,

Tony

Thanks Markus for the great introduction! (notice that in his hurry, he 
forgot the second ":" in most of the queries. So if you were trying out, 
now you know where the problem was).

I wrote a tutorial text on Inline Queries:
http://wiki.ontoworld.org/index.php/Help:Inline_queries

Feel free to improve the text. Maybe something shorter and more 
structured would be nice as well, but I think you should be able to get 
all informations you need here.

I hope you like it!

All the best,
denny

Markus Krötzsch wrote:
> Hi,
> 
> just so you know what to do with inline queries, here comes a very brief 
> collection of examples. Every inline query is put between <ask> and </ask>.
> 
> Examples:
> 
> <ask>[[Category:Test]]</ask>
> Returns all articles in the category "Test" as a simple comma separated list. 
> This simple output is chosen whenever you search for single articles. If more 
> than one article or data-value is involved in the query, dynamic tables are 
> returned. You can click on the table headers for dynamic alphabetic/numeric 
> sorting.
> 
> <ask>[[is capital of:Germany]]</ask> 
> Returns every article that contains the annotation "[[is capital 
> of:Germany]]".
> 
> <ask>[[is capital of:*]]</ask> 
> Returns all annotated capitals in the wiki, together with the articles about 
> what they are captital of.
> 
> <ask>[[Category:City]]  [[is located in:France]]</ask> 
> Returns all cities in France.
> 
> <ask>[[population:=*]]</ask>
> Returns all articles that have some population assigned, together with this 
> population.
> 
> <ask>[[Category:City]] [[population:=>100,000]] [[is located 
> in::Germany]]</ask>
> Returns all German cities with at least 100,000 inhabitants.
> 
> Well, you get the idea ...
> 
> In addition, one can explicitly modify the formatting of the output by giving 
> parameters to <ask>. E.g. 
> 
> <ask format="ul"> ... </ask>
> for an un-orderd list
> 
> <ask format="ol"> ... </ask>
> for an ordered list
> 
> <ask format="table"> ... </ask>
> for a dynamic table
> 
> Finally, one can ask more complex queries by nesting questions. The tag for 
> this is <q>. E.g.
> 
> <ask>[[accepted by::<q>[[organized by::Max Völkel]]</q>]]</ask>
> Returns everytihng that was accepted on an event organized by Max.
> 
> 
> And all together now:
> 
> <ask>
>  [[Category:City]] 
>  [[is located in:Germany]]
>  [[population:=>100,000]] 
>  [[has mayor::<q>[[Category:Woman]]</q>]] 
> </ask>
> 
> returns all large German cities which have a female mayor.
> 
> There are some more features to be described in detail soon, but this might 
> get you started a bit :-)
> 
> 
> Best,
> 
> Markus
>

On Mon, May 15, 2006 at 05:10:48PM +0200, Denny Vrandecic wrote:
> I wrote a tutorial text on Inline Queries:
> http://wiki.ontoworld.org/index.php/Help:Inline_queries

Excellent! Thanks for this. The <ask> stuff is fantastic!


I've a few issues though. As per earlier email I can't get the table to
sort. If you have a look at http://bible.tmtm.com/wiki/King_of_Judah I
can't work out how to get this to sort by the start date, rather than
by the King's name. I note that when displaying the column headers in
the table there are a couple of extra spaces appearing after the text -
perhaps this has something to do with it?

I also can't get the alternative display to work for the first column:

<ask format="table" sort="rule start" order="desc">
  [[ruler of::Judah]] [[rule start:=*|Start]] [[rule end:=*|End]]
</ask>

changes the headers for Start and End ok, but if I change the first
atom to
  [[ruler of::Judah|King]] 
I get no results.

Am I doing something wrong?

Thanks 


Tony

On Sun, May 14, 2006 at 03:51:23PM +0100, Tony Bowden wrote:
> I have the query:
> 
>   <ask format="table" sort="rule start" order="desc">
>    [[ruler of::Judah]] [[rule start:=*]] [[rule end:=*]]
>   </ask>
> But the results are sorted by the king's name, rather than the start date. 

It seems that I need to have an underscore in the sort:

  sort="rule_start"

rather than

  sort="rule start"

I'm assuming this is a bug, rather than by design?

If so the following patch seems to fix this:


--- SMW_InlineQueries.php.orig  2006-05-15 21:11:57.000000000 +0100
+++ SMW_InlineQueries.php       2006-05-15 21:14:04.000000000 +0100
@@ -326,8 +326,9 @@

        $order = "page_title";
        if (array_key_exists("sort", $param)) {
-               if (array_key_exists(ucfirst($param["sort"]), $rename)) {
-                       $order = $rename[ ucfirst($param["sort"]) ] ."o";
+        $sterm = smwfNormalizeTitle($param["sort"]);
+               if (array_key_exists($sterm, $rename)) {
+                       $order = $rename[$sterm] ."o";
                }
        }
        if (array_key_exists("order", $param)) {



Tony

Yes, this was a bug. Sorry for that -- and thanks for the fix!

denny

Tony Bowden wrote:
> On Sun, May 14, 2006 at 03:51:23PM +0100, Tony Bowden wrote:
>> I have the query:
>>
>>   <ask format="table" sort="rule start" order="desc">
>>    [[ruler of::Judah]] [[rule start:=*]] [[rule end:=*]]
>>   </ask>
>> But the results are sorted by the king's name, rather than the start date. 
> 
> It seems that I need to have an underscore in the sort:
> 
>   sort="rule_start"
> 
> rather than
> 
>   sort="rule start"
> 
> I'm assuming this is a bug, rather than by design?
> 
> If so the following patch seems to fix this:
> 
> 
> --- SMW_InlineQueries.php.orig  2006-05-15 21:11:57.000000000 +0100
> +++ SMW_InlineQueries.php       2006-05-15 21:14:04.000000000 +0100
> @@ -326,8 +326,9 @@
> 
>         $order = "page_title";
>         if (array_key_exists("sort", $param)) {
> -               if (array_key_exists(ucfirst($param["sort"]), $rename)) {
> -                       $order = $rename[ ucfirst($param["sort"]) ] ."o";
> +        $sterm = smwfNormalizeTitle($param["sort"]);
> +               if (array_key_exists($sterm, $rename)) {
> +                       $order = $rename[$sterm] ."o";
>                 }
>         }
>         if (array_key_exists("order", $param)) {
> 
> 
> 
> Tony
> 
> 
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Semediawiki-devel mailing list
> Semediawiki-devel@...
> https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

> Excellent! Thanks for this. The <ask> stuff is fantastic!

Thanks.

> I also can't get the alternative display to work for the first column:
> 
> <ask format="table" sort="rule start" order="desc">
>   [[ruler of::Judah]] [[rule start:=*|Start]] [[rule end:=*|End]]
> </ask>
> 
> changes the headers for Start and End ok, but if I change the first
> atom to
>   [[ruler of::Judah|King]] 
> I get no results.
> 
> Am I doing something wrong?

No, I forgot to support these. :P

The problem here is that you can have several atoms, like this:
<ask>[[Category:King]] [[Category:Saint]]</ask>
Both could state a replacement text. Which one to use? (Actually, I 
would go for "any")

And what about
<ask>[[email:=*]]</ask>
to just get an Email-list? How to name the first row here? (Maybe we 
could argue, "well, not at all")

So, what would be the better solution here? i see two.
1) Allow users to use [[Category:King|King]] to name the column. if 
there are several conflicting names specified, use any.
2) Allow an additional <ask> attribute: <ask 
header="King">[[Category:King]] [[rule start:=*|Start]]</ask>

The first one is more consistent with the rest. The second one solves 
also the Email-problem above.

Oh, I just noticed, there's a further solution: "allow both", but that 
raises complexity...

Any thoughts?

Cheers,
denny

> So, what would be the better solution here? i see two.
> 1) Allow users to use [[Category:King|King]] to name the column. if 
> there are several conflicting names specified, use any.

I'd go with that one. Having it be undefined which is used is fine with
me, as it's within the user's power to 'fix' any problem it causes.

> 2) Allow an additional <ask> attribute: <ask 
> header="King">[[Category:King]] [[rule start:=*|Start]]</ask>

This gets confusing as ask can return a table, and 'header' here doesn't
relate to the table, but rather to one column of it.

Thanks,

Tony