thks a lot sergiu :) its a bit quicker than writing by myself ;) Pascal
On Sat, Dec 19, 2009 at 2:14 AM, Sergiu Dumitriu <[email protected]> wrote: > On 12/18/2009 06:45 PM, Helenc wrote: > > > > Thanks Pascal that's very helpful! > > > > Now is there a way to dynamically include all the people when you view > > a page with a CompanyClass instance? > > > > Any clues on how to leverage a HQL query to display related people and > > companies? > > See > > http://www.xwiki.org/xwiki/bin/view/FAQ/HowToCreateAOneToManyRelationshipInXWiki > > > On 18/12/2009, at 3:56 PM, Pascal Voitot [via XWiki] wrote: > > > >> Just for information, > >> you can "simulate" a ONE2MANY relation with dblists. > >> As far as I can remember (I don't have my XWiki in front of me): > >> you create a class CompanyClass with a field that you will manage by > >> yourself as a unique primary key. For example the property "name" of > >> the > >> company. Each company has a different name. > >> > >> Then you create a class PersonClass with a DBStringList property > >> called > >> "company" and in the form, you set XWikiClass to "CompanyClass" and > >> property > >> to "name" and you set the way to choose the company to "select". > >> > >> Then you create some CompanyClass Objects. > >> So when you create a new PersonClass Object, in the inline editor, you > >> should see a list with all the companies names you created. In fact, > >> XWiki > >> performs a HQL request to retrieve a list of the "name" properties > >> for all > >> CompanyClass objects. > >> > >> It is not a real DB relation as you can imagine in hibernate because > >> there > >> is no physical relationship between 2 table Person and Company. So > >> if a > >> Person has a company property set to a given value and then you > >> change this > >> Company object property "name", the Person is not aware about it and > >> will > >> keep the former name. > >> Anyway, this is quite practical in most cases. > >> > >> You can even manage multiple values with a separator. > >> I use it intensively on my side and I love it :) > >> > >> Pascal > >> > >> On Fri, Dec 18, 2009 at 10:49 AM, Helenc<[hidden email]> wrote: > >> > >>> > >>> Hi All, > >>> > >>> I would really like to be able to mimic one to many relations > >> through > >>> classes somehow? > >>> > >>> I noticed there have been a few posts about how one might go about > >> such a > >>> thing using dblists, it's not clear yet to me how I could > >> implement such a > >>> thing? I'm wondering if any demo application exist that might give > >> me more > >>> of a clue? > >>> > >>> Let's say I want to set up a simple one to many relationship between > >>> information about a company and then individuals who worked for that > >>> company. How would I go about such a thing? > >>> > >>> Do I setup a companyclass and a personsclass and then link them > >> somehow > >>> with > >>> the dblist? > >>> > >>> What's the best user interface setup for this too so it's easy for > >> users to > >>> enter company and people data? > >>> > >>> Are there any examples of HQL queries about how one would then > >> search to > >>> display individuals details along with elements of their companies > >> details? > >>> Referencing the relationship? > >>> > >>> Or is there another way to do this? Any pointers would be very much > >>> appreciated? > >>> > >>> Thanks > >>> Helen > > -- > Sergiu Dumitriu > http://purl.org/net/sergiu/ > _______________________________________________ > devs mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/devs > _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs
