2 Mar
2016
2 Mar
'16
11:49 a.m.
On Thu, Feb 25, 2016 at 1:33 PM, Peter Huisman <p.huisman(a)ximm.nl> wrote:
Hi,
I have the following question.
I have an main wiki (xwiki) and a subwiki (test)
I want to access objects from class ’space.someclassClass’ located on a
page ‘space.somepage' in the main wiki
When in the subwiki, I have a query such as:
String query = "select name.value from XWikiDocument doc, BaseObject obj,
StringProperty name where doc.fullName=obj.name and
obj.className=‘space.someclassClass’ and” +
"obj.className<>’space.someclassTemplate’ and name.id.id=obj.id
order by doc.title"
List<java.lang.Object[]> results = (List<java.lang.Object[]>) (List)
this.queryManager.createQuery(query, Query.XWQL).setWiki(“xwiki").execute();
This gives me the name.value of the property of the object in the main
wiki.
What I need however is something like:
String query = "select obj from XWikiDocument doc, BaseObject obj where
doc.fullName=obj.name and obj.className=‘space.someclassClass’ and” +
"obj.className<>’space.someclassTemplate’ order by doc.title”
I expect this to return a BaseObject. When displaying
this
(toXMLString()), it is however an empty object:
<?xml version="1.0" encoding="UTF-8"?>
<object>
<name>space.somepage</name>
<number>0</number>
<className>space.someclassClass</className>
<guid>3c145abe-b334-4801-a100-24c8ef2eea9f</guid>
</object>
If you check
http://platform.xwiki.org/xwiki/bin/view/DevGuide/DatabaseSchema you'll see
that the object data is spread in multiple database tables. What you get is
only the information from the xwikiobjects table (that corresponds to
BaseObject from your query). That's why you need to join StringProperty (in
your first query) if you want the value of a string property from your
object. Since an object can have many properties, it's not convenient to
join all the tables for all the properties. You can instead select the page
full name and the object number, and then use the scripting API to access
the object from the corresponding document.
Hope this helps,
Marius
There is no way (that I have tried) that would give me the object of class
“xwiki:space.someclassClass” that contains the properties that I need (and
get using the first query).
I expect that it might have to do with the context but I’m not that
familiar with it that I know how to do this.
Can someone please shed some light on this?
With kind regards,
Peter Huisman
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users