Re: [xwiki-devs] mimic relational database one to many relations

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 <truckfin(a)hotmail.com> wrote: