[xwiki-users] DBlist with external query data?
Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database.
I'd like to do the same :) -----Original Message----- From: users [mailto:[email protected]] On Behalf Of Bryn Jeffries Sent: Tuesday, October 7, 2014 8:54 PM To: [email protected] Subject: [xwiki-users] DBlist with external query data? Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database. _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
On 8 Oct 2014 at 06:24:53, Jason Clemons ([email protected](mailto:[email protected])) wrote:
I'd like to do the same :)
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Bryn Jeffries Sent: Tuesday, October 7, 2014 8:54 PM To: [email protected] Subject: [xwiki-users] DBlist with external query data?
Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database.
No, you cannot do that with DBList. It’s expecting a HQL query actually (and we’ve been needing to add support for XWQL too for a very long time). Another direction could be to look at adding a new type for that, see http://platform.xwiki.org/xwiki/bin/view/DevGuide/CreatingNewXClassPropertyT... (I don’t know if it would work though, it may be too tied to the XWiki data model). Too bad that Computed Field only supports one value... Thanks -Vincent
On Wed, Oct 8, 2014 at 9:50 AM, [email protected] <[email protected]> wrote:
On 8 Oct 2014 at 06:24:53, Jason Clemons ([email protected](mailto:[email protected])) wrote:
I'd like to do the same :)
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Bryn Jeffries Sent: Tuesday, October 7, 2014 8:54 PM To: [email protected] Subject: [xwiki-users] DBlist with external query data?
Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database.
No, you cannot do that with DBList. It’s expecting a HQL query actually (and we’ve been needing to add support for XWQL too for a very long time).
Another direction could be to look at adding a new type for that, see http://platform.xwiki.org/xwiki/bin/view/DevGuide/CreatingNewXClassPropertyT... (I don’t know if it would work though, it may be too tied to the XWiki data model).
You don't really need a complete new type, you can provide a custom displayer for your field. See "Custom Display" property in the field definition in your class.
Too bad that Computed Field only supports one value...
Thanks -Vincent
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
On Wed, Oct 8, 2014 at 9:59 AM, Thomas Mortagne <[email protected]> wrote:
On Wed, Oct 8, 2014 at 9:50 AM, [email protected] <[email protected]> wrote:
On 8 Oct 2014 at 06:24:53, Jason Clemons ([email protected](mailto:[email protected])) wrote:
I'd like to do the same :)
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Bryn Jeffries Sent: Tuesday, October 7, 2014 8:54 PM To: [email protected] Subject: [xwiki-users] DBlist with external query data?
Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database.
No, you cannot do that with DBList. It’s expecting a HQL query actually (and we’ve been needing to add support for XWQL too for a very long time).
Another direction could be to look at adding a new type for that, see http://platform.xwiki.org/xwiki/bin/view/DevGuide/CreatingNewXClassPropertyT... (I don’t know if it would work though, it may be too tied to the XWiki data model).
You don't really need a complete new type, you can provide a custom displayer for your field. See "Custom Display" property in the field definition in your class.
See http://extensions.xwiki.org/xwiki/bin/view/Extension/User+Property+Custom+Di... for example for an example of custom field displayer.
Too bad that Computed Field only supports one value...
Thanks -Vincent
_______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- Thomas Mortagne
-- Thomas Mortagne
On 8 Oct 2014 at 10:01:52, Thomas Mortagne ([email protected](mailto:[email protected])) wrote:
On Wed, Oct 8, 2014 at 9:59 AM, Thomas Mortagne wrote:
On Wed, Oct 8, 2014 at 9:50 AM, [email protected] wrote:
On 8 Oct 2014 at 06:24:53, Jason Clemons ([email protected](mailto:[email protected])) wrote:
I'd like to do the same :)
-----Original Message----- From: users [mailto:[email protected]] On Behalf Of Bryn Jeffries Sent: Tuesday, October 7, 2014 8:54 PM To: [email protected] Subject: [xwiki-users] DBlist with external query data?
Please forgive my ignorance, but is it possible to use DBList with queries to other databases? I'd very much like to use this element populated with the results from a query to another database running on the same server as XWiki, but the only documentation I can find describes queries of the XWiki database.
No, you cannot do that with DBList. It’s expecting a HQL query actually (and we’ve been needing to add support for XWQL too for a very long time).
Another direction could be to look at adding a new type for that, see http://platform.xwiki.org/xwiki/bin/view/DevGuide/CreatingNewXClassPropertyT... (I don’t know if it would work though, it may be too tied to the XWiki data model).
You don't really need a complete new type, you can provide a custom displayer for your field. See "Custom Display" property in the field definition in your class.
See http://extensions.xwiki.org/xwiki/bin/view/Extension/User+Property+Custom+Di... for example for an example of custom field displayer.
And once you’ve succeeded you could publish a code snippet on extensions.xwiki.org to help others in the future! :) Thanks -Vincent
Too bad that Computed Field only supports one value...
Thanks -Vincent
participants (4)
-
Bryn Jeffries -
Jason Clemons -
Thomas Mortagne -
vincent＠massol.net