Awesome! You did it!
Turned out, I had to change the casing of this line:
<entity name="location_feature" query="select featureid from
location_features where locationid='${location.ID}'">
to:
<entity name="location_feature" query="select featureid from
location_features where locationid='${location.id}'">
Now the resultset is like this:
<response>
−
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">16</int>
−
<lst name="params">
<str name="indent">on</str>
<str name="start">0</str>
<str name="q">*:*</str>
<str name="version">2.2</str>
<str name="rows">10</str>
</lst>
</lst>
−
<result name="response" numFound="3" start="0">
−
<doc>
−
<arr name="cat">
<str>Gemeentehuis</str>
</arr>
−
<arr name="features">
<str>Tuin</str>
<str>Cafe</str>
</arr>
<str name="id">1</str>
<date name="timestamp">2010-08-03T17:31:21.562Z</date>
<str name="title">Gemeentehuis Nijmegen</str>
</doc>
−
<doc>
−
<arr name="cat">
<str>Gemeentehuis</str>
</arr>
−
<arr name="features">
<str>Tuin</str>
<str>Cafe</str>
<str>Danszaal</str>
</arr>
<str name="id">2</str>
<date name="timestamp">2010-08-03T17:31:21.593Z</date>
<str name="title">Gemeentehuis Utrecht</str>
</doc>
−
<doc>
−
<arr name="cat">
<str>Strand & Zee</str>
</arr>
−
<arr name="features">
<str>Strand</str>
<str>Cafe</str>
<str>Danszaal</str>
</arr>
<str name="id">3</str>
<date name="timestamp">2010-08-03T17:31:21.609Z</date>
<str name="title">Beachclub Vroeger</str>
</doc>
</result>
</response>
And now the FINAL question I have:
as you can see above "features" is a facet.
What should I type in the solr admin page on
http://localhost:8983/solr/db/admin/
to filter all records on the "features" facet?
e.g. to show all records that have a feature "Cafe"?
Thanks!
--
View this message in context:
http://lucene.472066.n3.nabble.com/Indexing-data-on-MSSQL-failed-Caused-by-org-apache-solr-common-SolrException-Error-loading-class-com-tp1015137p1020051.html
Sent from the Solr - User mailing list archive at Nabble.com.
