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
