Re: [xwiki-users] Class with DB List multiselect

4 Apr 2015

      Hi,

On Fri, Apr 3, 2015 at 9:25 PM, Gerritjan Koekkoek <
[email protected]> wrote:
...
...
I would like to create a form for a international audience (multi language)
So I created a AppWithinMinutes app.
I would like that my users can Multiselect from a list that is a selection
of objects based on a class.
So i created a class (with AppWithinMinutes:
Class properties
Short Text (shortText1: String)
Long Text (longText1: TextArea)
Long Text (longText2: TextArea)
Database List (databaseList1: Database List)
The databaseList1 has the following properties:
DisplayType: checkbox
Multiple Select: true
XWiki Class Name: XWiki.UIExtensionClass
Id Field Name: name ()
Value Field Name: name
The first issue I get that I get all objects of the class. I hoped to add a
selection by adding this query:
from doc.object(XWiki.UIExtensionClass) as obj where
lower(obj.extensionPointId) like '%cdlsworld.standardized.questionaires%'
and ('wiki' = obj.scope) order by obj.name
But how can I add this?
==Eduard replied
Why not use the HQL Query option for the DBList property? It's right next
to the Class Name option.
Have a look at
http://dev.xwiki.org/xwiki/bin/view/Drafts/DatabaseListProperties and
http://www.xwiki.org/xwiki/bin/view/FAQ/HowToCreateAOneToManyRelationshipInX...
for more details.
===========
That works, I used the xwql -> hql converter script-snippet to convert the xwql
select doc.fullName as id
         ,doc.title as value
  from XWikiDocument as doc 
        , BaseObject as obj 
        , com.xpn.xwiki.objects.StringProperty as obj_extensionPointId1
        , com.xpn.xwiki.objects.StringProperty as obj_scope2
        , com.xpn.xwiki.objects.StringProperty as obj_name3 
where ( lower ( obj_extensionPointId1.value ) like '%cdlsworld.standardized.questionaires%' 
    and ( 'wiki' = obj_scope2.value ) ) and doc.fullName=obj.name 
    and obj.className='XWiki.UIExtensionClass' 
    and obj_extensionPointId1.id.id=obj.id 
    and obj_extensionPointId1.id.name='extensionPointId' 
    and obj_scope2.id.id=obj.id 
    and obj_scope2.id.name='scope' 
    and obj_name3.id.id=obj.id 
    and obj_name3.id.name='name' 
order by obj_name3.value
...
...
The second issue that I hoped to be able to use for the option to add the
translated value
$services.localization.get('$value')
Eduard replied:
==========
What is $value? The document name returned by the above query?
The value is now replaced by doc.title.
The documents returned have a title in the following format:
$services.localization.render('cdlsworld.standardized.questionaires.cdlsqweApplication')

The issue is that in the form I do get the as doc.title the velocity script:
$services.localization.render('cdlsworld.standardized.questionaires.cdlsqweApplication')
in the doc itself this title is evaluated as: "Social and Physical abilities" and I had hoped this would be the displayed item in the select list
...
Thanks,
Eduard
...
...
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users

users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users