Re: [xwiki-users] Still issues with livetables - author property display ?

2010-03-02 Thread Jeremie BOUSQUET
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_HIDDEN1 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.bousq...@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

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-03-02 Thread Jeremie BOUSQUET
Hi,

I added a comment on issue http://jira.xwiki.org/jira/browse/XWIKI-4887,
because I found another issue that relates, IMO.

New problem is when some StringProperty fields contain character '  '. In
this case, JSON seems to be broken as character is not escaped, as it is in
doc_title for example.

Found this in XWiki 2.2.1. I did not re-test the previous issue about
carriage-return, though.

If you prefer I can open another issue for this instead of a comment, please
let me know,

Jeremie


2010/2/12 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 I checked, and without carriage returns it works, so I created the issue :
 http://jira.xwiki.org/jira/browse/XWIKI-4887

 Thanks again,
 Jeremie

 2010/2/12 Sergiu Dumitriu ser...@xwiki.com

 On 02/12/2010 03:05 PM, Jeremie BOUSQUET wrote:
  Wow, I'm afraid I understood ...
 
  In fact I read subjects from emails, and it happens that some have ...
  carriage return inside :( This does not please json validator at all ...

 This is also a bug, please report it on jira.xwiki.org

  I will correct this and see if it's better. I never though there could
 be
  carriage return characters in mails subjects :(
 
  Thanks again,
  Jeremie
 
  2010/2/12 Jeremie BOUSQUETjeremie.bousq...@gmail.com
 
  Thanks for the link,
 
  No it does not seem to be happy :
 
  syntax error, unexpected TINVALID at line 44
  Parsing failed
 
  But I don't understand what's about TINVALID, and there's nothing
  noticeable for me at line 44 ... So I'm a bit confused ...
 
  BR,
  Jeremie
 
  2010/2/12 Jerome Velociterjer...@xwiki.com
 
  Hello Jeremie,
 
  On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate,
 but
  a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine.
 There
  are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
   subject : { type : text , link:view,
  size :
  50, filterable: true, sortable:true},
   startdate :  { type : text,
  filterable:false,
  sortable:true}
 })
  #set($options = { className:My.Class,
  tagCloud:true,
  rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing 3
 to
  4
  letters of an existing subject, then SOMETIMES, it displays the
  related
  objects, but not always. Result is identical if I put the velocity
 part
  in
  1.0 syntax page. Tried to play and remove most of the fields options,
  still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the logs,
 put
  it
  in my browser, and it generates some JSON with 10 elements, as
 expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.
 
  Can you check and make sure the JSON is valid ?
 
  You can use http://www.jsonlint.com/ for example
 
  Thanks,
  Jerome.
 
 
  How could I investigate this issue ? Do you think it might be related
 to
  my
  installation ? Because all other livetables in the wiki work well,
  except
  some of them that are linked to custom classes (alldocs works pretty
  well).
  Could it be some special characters in subject text ? ('/', '[',
 ...
  ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie


 --
 Sergiu Dumitriu
 http://purl.org/net/sergiu/
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users



___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-03-02 Thread Jeremie BOUSQUET
I continue with my livetables experimentation ...

Found an (ugly) workaround, updating XWiki.LiveTableResultsMacro and adding
the following treatment :

#set($fieldvalue = $xwiki.getXMLEncoded($fieldvalue))
#set($fielddisplayvalue = $xwiki.getXMLEncoded($fielddisplayvalue))

It's particularly ugly because I do it for all fields. I wanted to filter on
$proptype value, but it seems $proptype is always empty (I debugged it in
the json).

Don't know how it relates, but here is the URL GET to generate the JSON :

http://myhost/xwiki/bin/view/XWiki/LiveTableResults?xpage=plainoutputSyntax=plaintransprefix=classname=MailArchiveCode.MailTopicClasscollist=subjectsubject_class=$%7BpropClassName%7Doffset=1limit=10reqNo=1sort=subjectdir=desc

I'm not sure it's normal to have url encoded ${propClassName} as values
for subject_class ?

With this workaround it works well and display is fine.

Jeremie


2010/3/2 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 Hi,

 I added a comment on issue http://jira.xwiki.org/jira/browse/XWIKI-4887,
 because I found another issue that relates, IMO.

 New problem is when some StringProperty fields contain character '  '. In
 this case, JSON seems to be broken as character is not escaped, as it is in
 doc_title for example.

 Found this in XWiki 2.2.1. I did not re-test the previous issue about
 carriage-return, though.

 If you prefer I can open another issue for this instead of a comment,
 please let me know,


 Jeremie


 2010/2/12 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 I checked, and without carriage returns it works, so I created the issue :
 http://jira.xwiki.org/jira/browse/XWIKI-4887

 Thanks again,
 Jeremie

 2010/2/12 Sergiu Dumitriu ser...@xwiki.com

 On 02/12/2010 03:05 PM, Jeremie BOUSQUET wrote:
  Wow, I'm afraid I understood ...
 
  In fact I read subjects from emails, and it happens that some have ...
  carriage return inside :( This does not please json validator at all
 ...

 This is also a bug, please report it on jira.xwiki.org

  I will correct this and see if it's better. I never though there could
 be
  carriage return characters in mails subjects :(
 
  Thanks again,
  Jeremie
 
  2010/2/12 Jeremie BOUSQUETjeremie.bousq...@gmail.com
 
  Thanks for the link,
 
  No it does not seem to be happy :
 
  syntax error, unexpected TINVALID at line 44
  Parsing failed
 
  But I don't understand what's about TINVALID, and there's nothing
  noticeable for me at line 44 ... So I'm a bit confused ...
 
  BR,
  Jeremie
 
  2010/2/12 Jerome Velociterjer...@xwiki.com
 
  Hello Jeremie,
 
  On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate,
 but
  a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine.
 There
  are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
   subject : { type : text , link:view,
  size :
  50, filterable: true, sortable:true},
   startdate :  { type : text,
  filterable:false,
  sortable:true}
 })
  #set($options = { className:My.Class,
  tagCloud:true,
  rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing 3
 to
  4
  letters of an existing subject, then SOMETIMES, it displays the
  related
  objects, but not always. Result is identical if I put the velocity
 part
  in
  1.0 syntax page. Tried to play and remove most of the fields
 options,
  still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the logs,
 put
  it
  in my browser, and it generates some JSON with 10 elements, as
 expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.
 
  Can you check and make sure the JSON is valid ?
 
  You can use http://www.jsonlint.com/ for example
 
  Thanks,
  Jerome.
 
 
  How could I investigate this issue ? Do you think it might be
 related to
  my
  installation ? Because all other livetables in the wiki work well,
  except
  some of them that are linked to custom classes (alldocs works pretty
  well).
  Could it be some special characters in subject text ? ('/', '[',
 ...
  ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie


 --
 Sergiu Dumitriu
 http://purl.org/net/sergiu/
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users




___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-03-02 Thread Jeremie BOUSQUET
Something else : not very important maybe, but macro #grid_addcolumn seems
to be duplicated in XWiki.LiveTableResultsMacro. Is there a reason ? I
removed one of the duplicates, and it seems to work as expected ...


2010/3/2 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 I continue with my livetables experimentation ...

 Found an (ugly) workaround, updating XWiki.LiveTableResultsMacro and adding
 the following treatment :

 #set($fieldvalue = $xwiki.getXMLEncoded($fieldvalue))
 #set($fielddisplayvalue = $xwiki.getXMLEncoded($fielddisplayvalue))

 It's particularly ugly because I do it for all fields. I wanted to filter
 on $proptype value, but it seems $proptype is always empty (I debugged it in
 the json).

 Don't know how it relates, but here is the URL GET to generate the JSON :


 http://myhost/xwiki/bin/view/XWiki/LiveTableResults?xpage=plainoutputSyntax=plaintransprefix=classname=MailArchiveCode.MailTopicClasscollist=subjectsubject_class=$%7BpropClassName%7Doffset=1limit=10reqNo=1sort=subjectdir=desc

 I'm not sure it's normal to have url encoded ${propClassName} as values
 for subject_class ?

 With this workaround it works well and display is fine.

 Jeremie


 2010/3/2 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 Hi,

 I added a comment on issue http://jira.xwiki.org/jira/browse/XWIKI-4887,
 because I found another issue that relates, IMO.

 New problem is when some StringProperty fields contain character '  '. In
 this case, JSON seems to be broken as character is not escaped, as it is in
 doc_title for example.

 Found this in XWiki 2.2.1. I did not re-test the previous issue about
 carriage-return, though.

 If you prefer I can open another issue for this instead of a comment,
 please let me know,


 Jeremie


 2010/2/12 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 I checked, and without carriage returns it works, so I created the issue
 :
 http://jira.xwiki.org/jira/browse/XWIKI-4887

 Thanks again,
 Jeremie

 2010/2/12 Sergiu Dumitriu ser...@xwiki.com

 On 02/12/2010 03:05 PM, Jeremie BOUSQUET wrote:
  Wow, I'm afraid I understood ...
 
  In fact I read subjects from emails, and it happens that some have ...
  carriage return inside :( This does not please json validator at all
 ...

 This is also a bug, please report it on jira.xwiki.org

  I will correct this and see if it's better. I never though there could
 be
  carriage return characters in mails subjects :(
 
  Thanks again,
  Jeremie
 
  2010/2/12 Jeremie BOUSQUETjeremie.bousq...@gmail.com
 
  Thanks for the link,
 
  No it does not seem to be happy :
 
  syntax error, unexpected TINVALID at line 44
  Parsing failed
 
  But I don't understand what's about TINVALID, and there's nothing
  noticeable for me at line 44 ... So I'm a bit confused ...
 
  BR,
  Jeremie
 
  2010/2/12 Jerome Velociterjer...@xwiki.com
 
  Hello Jeremie,
 
  On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate,
 but
  a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine.
 There
  are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
   subject : { type : text , link:view,
  size :
  50, filterable: true, sortable:true},
   startdate :  { type : text,
  filterable:false,
  sortable:true}
 })
  #set($options = { className:My.Class,
  tagCloud:true,
  rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing
 3 to
  4
  letters of an existing subject, then SOMETIMES, it displays the
  related
  objects, but not always. Result is identical if I put the velocity
 part
  in
  1.0 syntax page. Tried to play and remove most of the fields
 options,
  still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the
 logs, put
  it
  in my browser, and it generates some JSON with 10 elements, as
 expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.
 
  Can you check and make sure the JSON is valid ?
 
  You can use http://www.jsonlint.com/ for example
 
  Thanks,
  Jerome.
 
 
  How could I investigate this issue ? Do you think it might be
 related to
  my
  installation ? Because all other livetables in the wiki work well,
  except
  some of them that are linked to custom classes (alldocs works
 pretty
  well).
  Could it be some special characters in subject text ? ('/', '[',
 ...
  ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie


 --
 Sergiu Dumitriu
 http://purl.org/net/sergiu/
 ___
 users mailing list
 users@xwiki.org
 

[xwiki-users] Still issues with livetables - author property display ?

2010-03-01 Thread Jeremie BOUSQUET
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
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-02-12 Thread Jerome Velociter
Hello Jeremie,

On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
 Hello,

 I still have issues with livetables ... I'm willing to investigate, but a
 little help would be appreciated :)

 I'm basically wanting to show 2 fields of a custom class of mine. There are
 some hundreds of objects of this kind in my wiki.

 So I add the following in a page in 2.0 syntax

 {{velocity}}
 #set($collist = [ subject, startdate])
 #set($colprops = {
 subject : { type : text , link:view, size :
 50, filterable: true, sortable:true},
 startdate :  { type : text, filterable:false,
 sortable:true}
   })
 #set($options = { className:My.Class,
tagCloud:true,
rowCount: 10 })

 #livetable(myclass $collist $colprops $options)
 {{/velocity}}

 This results in an empty array displayed ... If I filter by typing 3 to 4
 letters of an existing subject, then SOMETIMES, it displays the related
 objects, but not always. Result is identical if I put the velocity part in
 1.0 syntax page. Tried to play and remove most of the fields options, still
 the same behaviour.

 I have retrieved the URL that generates the JSON data from the logs, put it
 in my browser, and it generates some JSON with 10 elements, as expected.
 There was an exception on date formatting though, so I removed the
 startdate field from the list, but still the same behaviour.

Can you check and make sure the JSON is valid ?

You can use http://www.jsonlint.com/ for example

Thanks,
Jerome.


 How could I investigate this issue ? Do you think it might be related to my
 installation ? Because all other livetables in the wiki work well, except
 some of them that are linked to custom classes (alldocs works pretty well).
 Could it be some special characters in subject text ? ('/', '[', ... ?)


 I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.

 Thanks for help,
 Jeremie
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-02-12 Thread Jeremie BOUSQUET
Thanks for the link,

No it does not seem to be happy :

syntax error, unexpected TINVALID at line 44
Parsing failed

But I don't understand what's about TINVALID, and there's nothing noticeable
for me at line 44 ... So I'm a bit confused ...

BR,
Jeremie

2010/2/12 Jerome Velociter jer...@xwiki.com

 Hello Jeremie,

 On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate, but a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine. There
 are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
  subject : { type : text , link:view, size
 :
  50, filterable: true, sortable:true},
  startdate :  { type : text, filterable:false,
  sortable:true}
})
  #set($options = { className:My.Class,
 tagCloud:true,
 rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing 3 to 4
  letters of an existing subject, then SOMETIMES, it displays the related
  objects, but not always. Result is identical if I put the velocity part
 in
  1.0 syntax page. Tried to play and remove most of the fields options,
 still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the logs, put
 it
  in my browser, and it generates some JSON with 10 elements, as expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.

 Can you check and make sure the JSON is valid ?

 You can use http://www.jsonlint.com/ for example

 Thanks,
 Jerome.

 
  How could I investigate this issue ? Do you think it might be related to
 my
  installation ? Because all other livetables in the wiki work well, except
  some of them that are linked to custom classes (alldocs works pretty
 well).
  Could it be some special characters in subject text ? ('/', '[', ... ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie
  ___
  users mailing list
  users@xwiki.org
  http://lists.xwiki.org/mailman/listinfo/users

 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-02-12 Thread Jeremie BOUSQUET
Wow, I'm afraid I understood ...

In fact I read subjects from emails, and it happens that some have ...
carriage return inside :( This does not please json validator at all ...

I will correct this and see if it's better. I never though there could be
carriage return characters in mails subjects :(

Thanks again,
Jeremie

2010/2/12 Jeremie BOUSQUET jeremie.bousq...@gmail.com

 Thanks for the link,

 No it does not seem to be happy :

 syntax error, unexpected TINVALID at line 44
 Parsing failed

 But I don't understand what's about TINVALID, and there's nothing
 noticeable for me at line 44 ... So I'm a bit confused ...

 BR,
 Jeremie

 2010/2/12 Jerome Velociter jer...@xwiki.com

 Hello Jeremie,

 On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate, but
 a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine. There
 are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
  subject : { type : text , link:view,
 size :
  50, filterable: true, sortable:true},
  startdate :  { type : text,
 filterable:false,
  sortable:true}
})
  #set($options = { className:My.Class,
 tagCloud:true,
 rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing 3 to
 4
  letters of an existing subject, then SOMETIMES, it displays the
 related
  objects, but not always. Result is identical if I put the velocity part
 in
  1.0 syntax page. Tried to play and remove most of the fields options,
 still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the logs, put
 it
  in my browser, and it generates some JSON with 10 elements, as expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.

 Can you check and make sure the JSON is valid ?

 You can use http://www.jsonlint.com/ for example

 Thanks,
 Jerome.

 
  How could I investigate this issue ? Do you think it might be related to
 my
  installation ? Because all other livetables in the wiki work well,
 except
  some of them that are linked to custom classes (alldocs works pretty
 well).
  Could it be some special characters in subject text ? ('/', '[', ...
 ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie
  ___
  users mailing list
  users@xwiki.org
  http://lists.xwiki.org/mailman/listinfo/users

 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users



___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-02-12 Thread Sergiu Dumitriu
On 02/12/2010 03:05 PM, Jeremie BOUSQUET wrote:
 Wow, I'm afraid I understood ...

 In fact I read subjects from emails, and it happens that some have ...
 carriage return inside :( This does not please json validator at all ...

This is also a bug, please report it on jira.xwiki.org

 I will correct this and see if it's better. I never though there could be
 carriage return characters in mails subjects :(

 Thanks again,
 Jeremie

 2010/2/12 Jeremie BOUSQUETjeremie.bousq...@gmail.com

 Thanks for the link,

 No it does not seem to be happy :

 syntax error, unexpected TINVALID at line 44
 Parsing failed

 But I don't understand what's about TINVALID, and there's nothing
 noticeable for me at line 44 ... So I'm a bit confused ...

 BR,
 Jeremie

 2010/2/12 Jerome Velociterjer...@xwiki.com

 Hello Jeremie,

 On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
 Hello,

 I still have issues with livetables ... I'm willing to investigate, but
 a
 little help would be appreciated :)

 I'm basically wanting to show 2 fields of a custom class of mine. There
 are
 some hundreds of objects of this kind in my wiki.

 So I add the following in a page in 2.0 syntax

 {{velocity}}
 #set($collist = [ subject, startdate])
 #set($colprops = {
  subject : { type : text , link:view,
 size :
 50, filterable: true, sortable:true},
  startdate :  { type : text,
 filterable:false,
 sortable:true}
})
 #set($options = { className:My.Class,
 tagCloud:true,
 rowCount: 10 })

 #livetable(myclass $collist $colprops $options)
 {{/velocity}}

 This results in an empty array displayed ... If I filter by typing 3 to
 4
 letters of an existing subject, then SOMETIMES, it displays the
 related
 objects, but not always. Result is identical if I put the velocity part
 in
 1.0 syntax page. Tried to play and remove most of the fields options,
 still
 the same behaviour.

 I have retrieved the URL that generates the JSON data from the logs, put
 it
 in my browser, and it generates some JSON with 10 elements, as expected.
 There was an exception on date formatting though, so I removed the
 startdate field from the list, but still the same behaviour.

 Can you check and make sure the JSON is valid ?

 You can use http://www.jsonlint.com/ for example

 Thanks,
 Jerome.


 How could I investigate this issue ? Do you think it might be related to
 my
 installation ? Because all other livetables in the wiki work well,
 except
 some of them that are linked to custom classes (alldocs works pretty
 well).
 Could it be some special characters in subject text ? ('/', '[', ...
 ?)


 I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.

 Thanks for help,
 Jeremie


-- 
Sergiu Dumitriu
http://purl.org/net/sergiu/
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users


Re: [xwiki-users] Still issues with livetables

2010-02-12 Thread Jeremie BOUSQUET
I checked, and without carriage returns it works, so I created the issue :
http://jira.xwiki.org/jira/browse/XWIKI-4887

Thanks again,
Jeremie

2010/2/12 Sergiu Dumitriu ser...@xwiki.com

 On 02/12/2010 03:05 PM, Jeremie BOUSQUET wrote:
  Wow, I'm afraid I understood ...
 
  In fact I read subjects from emails, and it happens that some have ...
  carriage return inside :( This does not please json validator at all ...

 This is also a bug, please report it on jira.xwiki.org

  I will correct this and see if it's better. I never though there could be
  carriage return characters in mails subjects :(
 
  Thanks again,
  Jeremie
 
  2010/2/12 Jeremie BOUSQUETjeremie.bousq...@gmail.com
 
  Thanks for the link,
 
  No it does not seem to be happy :
 
  syntax error, unexpected TINVALID at line 44
  Parsing failed
 
  But I don't understand what's about TINVALID, and there's nothing
  noticeable for me at line 44 ... So I'm a bit confused ...
 
  BR,
  Jeremie
 
  2010/2/12 Jerome Velociterjer...@xwiki.com
 
  Hello Jeremie,
 
  On 2/12/10 2:41 PM, Jeremie BOUSQUET wrote:
  Hello,
 
  I still have issues with livetables ... I'm willing to investigate,
 but
  a
  little help would be appreciated :)
 
  I'm basically wanting to show 2 fields of a custom class of mine.
 There
  are
  some hundreds of objects of this kind in my wiki.
 
  So I add the following in a page in 2.0 syntax
 
  {{velocity}}
  #set($collist = [ subject, startdate])
  #set($colprops = {
   subject : { type : text , link:view,
  size :
  50, filterable: true, sortable:true},
   startdate :  { type : text,
  filterable:false,
  sortable:true}
 })
  #set($options = { className:My.Class,
  tagCloud:true,
  rowCount: 10 })
 
  #livetable(myclass $collist $colprops $options)
  {{/velocity}}
 
  This results in an empty array displayed ... If I filter by typing 3
 to
  4
  letters of an existing subject, then SOMETIMES, it displays the
  related
  objects, but not always. Result is identical if I put the velocity
 part
  in
  1.0 syntax page. Tried to play and remove most of the fields options,
  still
  the same behaviour.
 
  I have retrieved the URL that generates the JSON data from the logs,
 put
  it
  in my browser, and it generates some JSON with 10 elements, as
 expected.
  There was an exception on date formatting though, so I removed the
  startdate field from the list, but still the same behaviour.
 
  Can you check and make sure the JSON is valid ?
 
  You can use http://www.jsonlint.com/ for example
 
  Thanks,
  Jerome.
 
 
  How could I investigate this issue ? Do you think it might be related
 to
  my
  installation ? Because all other livetables in the wiki work well,
  except
  some of them that are linked to custom classes (alldocs works pretty
  well).
  Could it be some special characters in subject text ? ('/', '[', ...
  ?)
 
 
  I'm on xwiki 2.2-RC2, tomcat 6, linux RH4.
 
  Thanks for help,
  Jeremie


 --
 Sergiu Dumitriu
 http://purl.org/net/sergiu/
 ___
 users mailing list
 users@xwiki.org
 http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users