Wiki source code of Database List
Version 1.1 by Vincent Massol on 2020/02/17
Show last authors
| author | version | line-number | content |
|---|---|---|---|
| 1 | Note that the following screenshot are taken from using [[AWM>>extensions:Extension.App Within Minutes Application]] but you'll find the same properties when using the class editor. | ||
| 2 | |||
| 3 | = Displaying XWikiDocument properties = | ||
| 4 | |||
| 5 | To display ##XWikiDocument## properties values like ##doc.title##, ##doc.author##, ##doc.fullName## (see full list on the [[Hibernate mapping document>>https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwiki-platform-oldcore/src/main/resources/xwiki.hbm.xml#L39]]) from another application (represented for example by the class ##Domains.Code.DomainClass##)you can use the following fields: | ||
| 6 | |||
| 7 | * ##XWIKI CLASS NAME## (the class for the application you want to pull the data from) | ||
| 8 | * ##ID FIELD NAME## (usually "doc.fullName" to uniquely identify the document(s) selected) | ||
| 9 | * ##VALUE FIELD NAME## (usually ##doc.title## because it represents the pretty name displayed to the user) | ||
| 10 | |||
| 11 | == AWM Example == | ||
| 12 | |||
| 13 | {{gallery}} | ||
| 14 | image:ClassnameExample.png | ||
| 15 | {{/gallery}} | ||
| 16 | |||
| 17 | = Displaying custom properties = | ||
| 18 | |||
| 19 | When you need to display a certain property value from another application (represented for example by the class ##application.Code.applicationClass##) inside the database list you should use the "Hibernate Query" field. For example, to fill in the list with the values of the property "shortText1" (property name automatically generated by the AWM wizard) for an AWM "application", the "Hibernate Query" field should use the following value (assuming "shortText1" is "Short Text" which means "StringProperty" for the [[Hibernate mapping>>https://github.com/xwiki/xwiki-platform/blob/master/xwiki-platform-core/xwiki-platform-oldcore/src/main/resources/xwiki.hbm.xml#L244]]): | ||
| 20 | |||
| 21 | {{code}} | ||
| 22 | select d.fullName, prop.id.value from XWikiDocument as d, BaseObject as o, | ||
| 23 | StringProperty as prop where o.name = d.fullName and o.className = 'application.Code.applicationClass' | ||
| 24 | and d.fullName <> 'application.Code.applicationTemplate' and o.id=prop.id.id and prop.id.name='shortText1' | ||
| 25 | {{/code}} | ||
| 26 | |||
| 27 | == AWM Example == | ||
| 28 | |||
| 29 | {{gallery}} | ||
| 30 | image:HQLExample.png | ||
| 31 | {{/gallery}} | ||
| 32 | |||
| 33 | == How it looks in a LiveTable == | ||
| 34 | |||
| 35 | * The "application list" property is displayed using a "database list" and the "Hibernate Query" above | ||
| 36 | * The "domains" property is displayed using a "database list" and the XWikiDocument properties | ||
| 37 | |||
| 38 | {{gallery}} | ||
| 39 | image:viewmode.png | ||
| 40 | |||
| 41 | image:editmode.png | ||
| 42 | {{/gallery}} |
