Hi,
I also think there might be a regression ...
I moved from 2.0.3 to 2.2.1, and now my livetable remains always empty.
So I checked the SQL generated by hibernate in logs, and found this (I
transcoded alias names for better readability) :
select distinct doc.XWD_WEB, doc.XWD_NAME, prop.XWS_VALUE
from xwikidoc doc, xwikiobjects obj, xwikistrings prop
inner join xwikiproperties prop2 on prop.XWS_ID=prop2.XWP_ID
and prop.XWS_NAME=prop2.XWP_NAME
where (doc.XWD_HIDDEN<>1 or doc.XWD_HIDDEN is null)
and obj.XWO_NAME=doc.XWD_FULLNAME
and obj.XWO_CLASSNAME='MailArchiveCode.MailTopicClass'
and doc.XWD_FULLNAME<>'MailArchiveCode.MailTopicClassTemplate'
and obj.XWO_ID=prop.XWS_ID
and prop.XWS_NAME='lastupdatedate'
order by prop.XWS_VALUE desc
Problem is, that property "lastupdatedate" is a DateProperty, and the query
queries for table xwikistrings instead of xwikidates ...
Trying this query in my sql browser returns nothing, but if I change
"xwikistrings" by "xwikidates", the correct list is returned.
In my #livetable call, I declared the property as a date - it's also the
selectedColumn :
...
"lastupdatedate" : { "type" : "date", "sortable" :
"true" },
...
"selectedColumn":"lastupdatedate",
...
If I remove the "selectedColumn" option, the livetable correctly displays
its content. If I click on column title to sort by dates, the content
disappears - for the same reason I believe.
I use MySQL 5.1. As hibernate mapping did not change between versions, I
believe it's something else...
Thanks for help,
Jeremie
2010/3/1 Jeremie BOUSQUET <jeremie.bousquet(a)gmail.com>
Hi,
Again with livetables ...
Here I have a livetable showing objects from a custom class. One of the
properties displayed is named "author". While the livetable shows well, and
the "author" properties are valued, the "author" column always
remains
empty.
As it contained some "<" ">" characters, I added
"html":"true" as a column
option, but still the column remains empty.
I was wondering, is there some mismatch between my "author" column and a
possible "author" property in xwiki ?
Note : I use XWiki 2.0.3, but I will soon test with 2.2.1 as I know there
were some improvements on livetables.
Thanks,
Jeremie