[xwiki-users] Livetable filtering format
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
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
participants (2)
-
oana.tabaranu -
Radek Rekas