search over two independent tables

2010-10-14 Thread Anthony Maudry
Hello, I'm using Solr with a postgreSQL database. I need to search across two tables with no link between them. ie : I have got a "messages" table and a "newsfeeds" table, nothing liking them. I tried to configure my data-config.xml to implement this but it seems that tables can't be defi

Re: search over two independent tables

2010-10-14 Thread Anthony Maudry
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

2010-10-14 Thread Anthony Maudry
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