lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mathias <mathias.mahlkne...@innofuture.com>
Subject OR two joins
Date Fri, 21 Oct 2016 08:36:03 GMT
Hello,

I have the following statement:

({!join from=project_uuid to=id}type:EM_PM_Timerecord AND
created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z]) OR ({!join
from=project_uuid to=id}type:EM_CM_Request_Member AND
created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z])

It doesn't return any documents, but if I use only one of the joins e.g.:

{!join from=project_uuid to=id}type:EM_PM_Timerecord AND
created:[2015-01-01T01:00:00Z TO 2016-01-01T01:00:00Z]

It returns some documents.

If I remove the date ranges it works as well:

({!join from=project_uuid to=id}type:EM_PM_Timerecord) OR ({!join
from=project_uuid to=id}type:EM_CM_Request_Member)

In debug the parsed query looks like this:

(+JoinQuery({!join from=project_uuid to=id}type:EM_PM_Timerecord)
+created:[1420074000000 TO 1451610000000]) (+JoinQuery({!join
from=project_uuid to=id}type:EM_CM_Request_Member) +created:[1420074000000
TO 1451610000000])

Can someone tell me what I'm missing? And what is wrong with the first
statement?

Thanks in advance,
Mathias 




--
View this message in context: http://lucene.472066.n3.nabble.com/OR-two-joins-tp4302415.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message