Thanks, I will give a try.
With ResultPage, I wonder if I could use select list of
livetable.
Hello,
I didn't used ExternalLinksJSON.xml example because I need tag cloud and all nice
livetable features :-)
Then I copy/paste XWiki.LiveTableResultsMacros in MyApply.MyResultPage and use this
lovetable option:
#set ($options = {
'resultPage':'MyApply.MyResultPage',
'translationPrefix' : 'FormSMQ.livetable.',
In MyApply.MyResultPage, I replace these lines (and add tons of debug code :-)) ):
#set($whereSql = "${whereSql} and ${objectAlias}.name = doc.fullName and
${objectAlias}.className = ?")
#set($discard = $whereParams.add($propClassName))
by
- ## Hack #set($whereSql = "${whereSql} and ${objectAlias}.name = doc.fullName and
${objectAlias}.className = ?")
#set($whereSql = "${whereSql} and ${objectAlias}.name = doc.fullName and
${objectAlias}.className like ? and doc.fullName NOT like
'FormSMQ.%Template'")
#set($discard = $whereParams.add('FormSMQ.%Class'))
and to avoid hidden doc when no filter is applied:
I replace
#set($sql = "$!fromSql $!filterfrom where 1=1 $!whereSql $!filterwhere")
by
#set($sql = "$!fromSql $!filterfrom where 1=1 and doc.hidden=false $!whereSql
$!filterwhere")
It seems that my livetable working like a charm now. :-)
By the way, it's a shame that boolean property didn't work with columnsProperties
with this :
#set ($columnsProperties = {
'MyBooleanPropertyField':
{"type":"list",'class':'xxxxx'},
It didn't work with text either.
Then I suppose I must change the property field type in a database list or in static
list.
Thxs for all
Pascal B
