Re: search over two independent tables

2010-10-14 Thread Allistair Crossley
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

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

Re: search over two independent tables

2010-10-14 Thread Allistair Crossley
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

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 Allistair Crossley
actually your intention is unclear ... are you wanting to run a single search and get back results from BOTH newsfeed and message? or do you want one or the other? if you want one or the other you could use my strategy which is to store the entity type as a field when indexing, e.g. note, i

Re: search over two independent tables

2010-10-14 Thread Allistair Crossley
your first example is correct i have the same config for indexing 5 different tables what you don't have from what i can see is a field name mapped to each column, e.g. i always have to provide the destination field in schema.xml, e.g. On Oct 14, 2010, at 5:22 AM, Anthony Maudry wrote: