Hi Moritz, On Mon, May 21, 2012 at 10:08 AM, Moritz Hesse (EA GmbH) <[email protected]> wrote:

Hi,

I have created two applications, let's say one for managing clients and one for managing projects. How can I fetch the clients name and use it in my list of projects?

To speak in database terms I want my project's table to have a foreign key which refers to the client primary key so that I can access all client's attributes.

Would be thankful for inspiration or helpful links to existing(?) tutorials.

Each application has a class that describes the type of data managed by the application (the client class and the project class in your case). By default a live table can display information taken from the instances of a single class. If you want a live table that aggregates ('join' in database language) data from instances of multiple classes then you have to write a custom live table results page. Live tables are fed with JSON generated by a wiki page. By default this page is XWiki.LiveTableResults but you can create your own results page. It's not trivial though.. Useful links: http://extensions.xwiki.org/xwiki/bin/view/Extension/Livetable+Macro http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module Hope this helps, Marius

Thanks and bests,

Moritz

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