Thanks, using firebug to take a look at the reponse of
the JSON page helped me to diagnose what the problem was.
The following blog post helped me with figuring out how to access the JSON used by the
livetable:
http://www.softwareishard.com/blog/firebug/json-explorer-for-firebug/
In case anyone else comes accross wondering how to do this it would appear that all of
the class properties are stored in seperate tables and the query parameter in the
gridresultwithfilter macro is used to filter on these tables. For my example I needed to
use the StringProperty table as the title property was set to type string in my xwiki
class. Integers appear to go in the IntegerProperty table and so on.
My example was the below where "title" was the field name in the xwiki class
that I was trying to filter on and "test6" was the field value.
#gridresultwithfilter($request.classname $request.collist.split(",") ",
StringProperty as stringtable", " and obj.id=stringtable.id.id and
stringtable.id.name='title' and stringtable.value='test6'")
Thanks again for pointing me in the right direction.
Radek Rekas
----- Original Message -----
From: oana.tabaranu<oana.tabaranu(a)xwiki.com>
Sent: Thu, 7/1/2010 11:22pm
To: XWiki Users<users(a)xwiki.org>
Subject: Re: [xwiki-users] Livetable filtering format
Hi Radek,
When writing custom code for the live table, I suggest you copy the
content from XWiki.LiveTableResultsMacros and paste it into your own
wiki page. Create a small example for the livetable that uses your wiki
page and debug the query and JSON generated by the macro using Firebug
or the direct URL in your browser.
This also might help:
http://platform.xwiki.org/xwiki/bin/view/DevGuide/LiveTable
Oana
On 07.01.2010 06:04, Radek Rekas wrote:
Hi,
I'm trying to get livetable filtering working however I'm having trouble figuring
out what objects/properties are available in the $filterfrom and $filterwhere parameters
of the gridresultwithmacro() macro contained in the XWiki.LiveTableResultsMacros
document.
I'm trying to filter the livetable to display only records where the
"title" field is set to "test" but setting the $filterwhere parameter
to " and obj.name='title' and obj.value='test'" does not seem to
work and I'm having trouble finding any documentation etc to find out what format
these where clauses should be in.
The closest documentation that ive been able to find is at the bottom of the following
page
http://dev.xwiki.org/xwiki/bin/view/Drafts/XWikiGridComponentTutorial however it
doesnt give much clues as to what format the $filterwhere and $filterfrom parameters (3rd
and 4th parameter) of the gridresultwithmacro() macro should be in.
The livetable displays all records correctly if I leave the $filterfrom and $filterwhere
parameters blank.
Can anyone offer any hints or point me to any relevant documentation?
Thanks,
Radek Rekas
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users