Re: [xwiki-users] How to filter livetable

Hi Phil, As you can read from the LiveTable Macro's documentation [1], the "queryFilters" parameter is used to specify which (already registered) query filter name to use in the query that is performed by the backend of the livetable macro that you are using. This is not the place where you would add "WHERE" clauses, but it`s for the actual name of existing query filters (e.g. "unique", "hidden", etc. See [2] 5th bullet). I`m not sure where you`ve got that example livetable or that "$4_0QueryFilter" variable. Now, it also depends what you want to achieve, since it was not very clear from your message. A) If you want to expose in the livetable the column called "version" which corresponds to the "version" field in an object of your class and make that column filterable by users, then you need to use the colmnProperties map and make sure your column has the "filterable" flag set to "true". See [3] for more details. B) If what you want to do is have the generated livetable be already filtered to a specific value of your "version" property (e.g. show *only* entries of version "1.0"), then you would need to create your custom livetable results page where you would use the "#gridresultwithfilter" velocity macro which allows in its 4th parameter to specify extra "WHERE" clauses to use in the query it is performing. Finally, use the "resultPage" parameter in your livetable display page to specify that you want to use your custom livetable results page that you have just created. Again, you have an example for this in the documentation [4].

Hope this helps, Eduard ---------- [1] http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro#HParam… [2] http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HFromVelo… [3] http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro#HParam… [4] http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro#HFilte… On Wed, Feb 24, 2016 at 3:15 PM, pgregoire <pgregoire(a)eddyfi.com> wrote: