Re: search over two independent tables

super On Oct 14, 2010, at 8:00 AM, Anthony Maudry wrote: > Sorry for the late answer. > > It works now thanks to you, Allistair. > > I needed to use your "uid" field, common to the two entities but built in > different ways. > > here is the result in a sample of the data-config.xml file > >

Re: search over two independent tables

Sorry for the late answer. It works now thanks to you, Allistair. I needed to use your "uid" field, common to the two entities but built in different ways. here is the result in a sample of the data-config.xml file ... ... ... ... uid is define as unique

Re: search over two independent tables

results from both tables with 1 search - your first suggestion with separate entities under document is right, or at least how i do it. things that i have often found ... 0. check stdout for SQL errors 1. verify that your SQL works when you run it direct on your database! 2. verify that your sea

Re: search over two independent tables

Thanks for your quick answer. Actually I need to get result from both tables from a single search. I tried to define correctly every fields as you told me in your previous message but I only get result from one table (actualy "Newsfeeds") Le 14/10/2010 11:49, Allistair Crossley a écrit : a

Re: search over two independent tables

;> >> >> >> >> >> >> >> >> Note that the two entities are at the same level. Only the first entity >> ("newsfeeds") will give results >> >> I then tried this config : >> >> >> > url="jdbc:postgresql://host/database" user="user" password="password" /> >> >> >> >> >> >> >> >> >> >> >> As expected the results were crossed. >> >> I wonder how I could implement the search over two independent tables? >> >> Thanks for any answer. >> >> Anthony >

Re: search over two independent tables

> > > > > > > > > Note that the two entities are at the same level. Only the first entity > ("newsfeeds") will give results > > I then tried this config : > > > url="jdbc:postgresql://host/database" user="user" p

search over two independent tables

uot;newsfeeds") will give results I then tried this config : url="jdbc:postgresql://host/database" user="user" password="password" /> As expected the results were crossed. I wonder how I could implement the search over two independent tables? Thanks for any answer. Anthony