Hi
(XWiki 2.7.2)
I've defined a class with a property defined as DatabaseList
It's a multi select
The Hibernate query is:
select ata.filename
from XWikiAttachment as ata,
XWikiDocument as doc
where doc.fullName ='CdLSAssociations.FlagAttachments'
and doc.id = ata.docId
order by ata.filename
This works fine, when I create a new object of this class I can select multiple
fileNames
My questions;
I would like to strip the filename extension from the ata.filename (ar.png =>
ar)
I was trying a substr(ata.filename,1,2) does not work
How do I do this?
Second, I wonder if it is possible to add a second collumn to the query that
uses a translation table
like
select ata.filename,
$msg.get(ata.filename) as translatedName
from XWikiAttachment as ata,
XWikiDocument as doc
where doc.fullName ='CdLSAssociations.FlagAttachments'
and doc.id = ata.docId
order by translatedName
and use in the class property defenition the ID Field name and Value Field Name
Any help is highly appreciated
Gerritjan
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
