Dear SOLR users,
I've found some facet postings and Erik's old slides Venn diagram slides but
still can't figure out the query to do the following.
"Find the Document_IDs where the word apples is mentioned in both <SECTION>
fields (each <Section> has its own unique ID <REFERENCE>)"
An example XML is listed below. In this case, a query returning only
Document_ID A would be the desired response.
I'm tying myself in knots trying to get this to work.
With thanks,
Paul
------ example XML ------
<?xml version="1.0" encoding="UTF-8"?><DOCS>
<DOCUMENT>
<Document_ID>A</Document_ID>
<REFERENCE>A-0</REFERENCE>
<SECTION>0</SECTION>
<CONTENT> apples oranges bananas pears </CONTENT>
</DOCUMENT>
<DOCUMENT>
<Document_ID>A</Document_ID>
<REFERENCE>A-1</REFERENCE>
<SECTION>1</SECTION>
<CONTENT> apples oranges </CONTENT>
</DOCUMENT>
<DOCUMENT>
<Document_ID>B</Document_ID>
<REFERENCE>B-0</REFERENCE>
<SECTION>0</SECTION>
<CONTENT> apples </CONTENT>
</DOCUMENT>
<DOCUMENT>
<Document_ID>B</Document_ID>
<REFERENCE>B-1</REFERENCE>
<SECTION>1</SECTION>
<CONTENT> oranges bananas </CONTENT>
</DOCUMENT>
<DOCUMENT>
<Document_ID>C</Document_ID>
<REFERENCE>C-0</REFERENCE>
<SECTION>0</SECTION>
<CONTENT> oranges </CONTENT>
</DOCUMENT>
<DOCUMENT>
<Document_ID>C</Document_ID>
<REFERENCE>C-1</REFERENCE>
<SECTION>1</SECTION>
<CONTENT> bananas </CONTENT>
</DOCUMENT>
</DOCS>
