14 Jun
2011
14 Jun
'11
3:20 a.m.
On 06/12/2011 05:39 PM, Gerritjan Koekkoek wrote:
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?
In theory you could use something like this:
select ata.filename, substring(ata.filename, 0, locate(ata.filename,
'.')) from XWikiAttachment...
But only in theory. There's a bug in the DBList query processor that
breaks that.
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
This can't work. There are two languages involved here, Velocity and
HQL, and they don't mix in real time.
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
I'd recommend that you write a custom displayer for this field, instead
of relying on the default display. You should use the first, simple
query that just retrieves the attachment names, then create you own
display that substrings the extension for the displayed option label.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/