Re: [xwiki-users] LivetableResults filter query

Use quotes and, for safety, encode the query string parameters: 'extraParams': "&assignee=$escapetool.url($xcontext.userReference.<http://xcontext.userreference.name/> name)" Check the Velocity documentation for the explanation (see string literals). Hope this helps, Marius On Jan 23, 2014 5:42 PM, "Kelly Steinke" &lt;ksteinke(a)steel-craft.ca&gt; wrote: value, unfortunately my livetable is still showing blank results. However when I replace the $xcontext.userReference.name with the hard-coded value 'test' like so: behaviour to me and I cannot seem to get this filter working. Even though I set the "List of Users" value to the currently logged in user with $context.user, I cannot seem to filter the table with any of the $context variables. wrote: and I have been trying to filter the results based on two properties status and assignee. As defined in the TaskManagerClass, status is a database list and assignee is a list of users (local subwiki users). I have defined the live table like so: {"sortable":false,"filterable":false,"html":true,"actions":["edit","delete"]} 'severity', 'reporter', 'assignee', 'duedate', '_actions']) $request.collist.split(",")", StringProperty as statusprop ", " and obj.id= statusprop.id.id and statusprop.id.name='status' and statusprop.value not in ('Done')" ) tasks that have a status other than "Done". I cannot however successfully get the results to also filter based on the currently logged in user. In the TaskManagerClass sheet I have set the assignee property automatically using $context.user when a new entry is made. I have tried to filter the table at the definition using the extraparams option like so: further investigation I found that when I display what is in the $context.user, it shows as " XWiki.test " (test being the name of the user I created for testing). The strange thing is that when I change the extraParams option to be ' extraParams' : '&assignee=test ' then it works. This means that when I set the default property in the List of Users with the same function ($context.user), that it set it as test as opposed to XWiki.test. I also tried using $context.localUser in the extraParams however that also displays as XWiki.test. form is storing the value from $context.user? How can I filter this live table on the currently logged in user. I have tried to add another object to my where clause in the gridreslutwithfilter() call, however I was unsuccessful. If anyone can help me out with that query or with using the extraParams I would greatly appreciate it.