21 May
2012
21 May
'12
11:37 a.m.
Hi Moritz,
On Mon, May 21, 2012 at 10:08 AM, Moritz Hesse (EA GmbH)
<moritz.hesse(a)ea-gmbh.de> 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
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users