Hi Andrea,
Here you go:
**data-config.xml**
<dataConfig>
<dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/wordp" user="***" password="***" />
<document name="articles">
<entity pk="ID" name="article" query="SELECT p.*, (
SELECT guid FROM wp_posts WHERE id = m.meta_value ) AS imgurl
FROM wp_posts p
LEFT JOIN wp_postmeta m ON(p.id = m.post_id AND m.meta_key =
'_thumbnail_id' )
WHERE p.post_type = 'post'
AND p.post_status = 'publish';">
<entity name="post_categories" query="select
wt.name as cat_name,wt.slug,wtr.term_taxonomy_id,wtt.term_id,wtt.taxonomy
from
wp_term_relationships wtr
INNER JOIN wp_term_taxonomy wtt ON
wtt.term_taxonomy_id=wtr.term_taxonomy_id AND wtt.taxonomy='category'
INNER JOIN wp_terms wt ON wt.term_id=wtt.term_taxonomy_id
where wtr.object_id='${article.id}';">
</entity>
</entity>
</document>
</dataConfig>
**schema.xml**
<field name="cat_name" type="text" indexed="true" stored="true"
multiValued="true" />
<field name="cat_name_raw" type="string" indexed="true"
stored="true" multiValued="true" />
<copyField source="cat_name" dest="cat_name_raw"/>
--
View this message in context:
http://lucene.472066.n3.nabble.com/Empty-facets-on-Solr-with-MySQL-tp4109170p4109353.html
Sent from the Solr - User mailing list archive at Nabble.com.
