Hi Pascal, You should not use " but ' You can try your query in a page with $xwiki.search() We have a bug in some version which does not allow to use "order by" in your query Ludovic Pascal Voitot wrote:
Hello, as you may now (or even may have coded), you can put a SQL query in a DBStringList property...
something like select prop.value from BaseObject as obj, StringProperty as prop where obj.name = "mydocname" and obj.className="myclassname" and obj.id.id = prop.id and prop.name = "mypropname"
but you can also use 2 columns (first one for stored value and second one for displayed value) select prop.value, prop2.value from BaseObject as obj, StringProperty as prop, StringProperty as prop2 where obj.name = "mydocname" and obj.className="myclassname" and obj.id.id = prop.id and prop.name = "mypropname" and obj.id.id = prop2.id and prop2.name = "myprop2name"
So then I have tried something more complex select prop.value, prop.value||prop2.value from BaseObject as obj, StringProperty as prop, StringProperty as prop2 where obj.name = "mydocname" and obj.className="myclassname" and obj.id.id = prop.id and prop.name = "mypropname" and obj.id.id = prop2.id and prop2.name = "myprop2name"
or
select prop.value, concat(prop.value, prop2.value) from BaseObject as obj, StringProperty as prop, StringProperty as prop2 where obj.name = "mydocname" and obj.className="myclassname" and obj.id.id = prop.id and prop.name = "mypropname" and obj.id.id = prop2.id and prop2.name = "myprop2name"
and it throws some funny errors... why? In DBStringListClass, makeList transforms the SQL query to separate both columns and re-creates SQL query with one column only. But apparently, it doesn't manage such expressions... the funniest is "||" since it looks like it is rendered as a Wiki expression...
regards Pascal _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
-- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost