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 :
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. <entity><field column="type" name="type_field" /></entity> <entity><field column="type" name="type_field" /></entity> note, if you don't have a foo column for type, make it up in your query, e.g. select n.*, 'Newsfeed' as type from ... then for silo'd searches you would want to ensure a filter of type:Newsfeed. another handy thing is to facet.field=type and search (without a filter) as then you'll get back counts for your Newsfeed Message results too.
