Hi Radek, Glad I could help. On 1/8/10 3:13 AM, Radek Rekas wrote:
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<[email protected]> Sent: Thu, 7/1/2010 11:22pm To: XWiki Users<[email protected]> 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Oana Tabaranu