Hi Peter,
I can only guess that the result set doesn't contain a "cat_name" (case
insensitive) column. Other option / question: do you have a transformer
(like scriptTransformer) that manipulates the resultset?
You can debug the resultset in a main class by doing rs.getString
("cat_name")
Cheers,
Andrea
On 3 Jan 2014 15:01, "PeterKerk" <[email protected]> wrote:
> 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.
>
