Hi, below is a simplified copy of my data-config file:
<dataConfig> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost/campaign" user="root" password=""/> <document name="campaigns"> <entity name="campaign" query="SELECT * FROM campaigns WHERE deleted_at IS NULL"> <field column="id" name="id" /> <field column="name" name="campaign_name" /> <entity name="banner" query="SELECT * FROM banners WHERE campaign_id=${campaign.id}"> <field name="banner_type" column="banner_type" /> <entity name="size" query="SELECT * FROM banner_sizes WHERE banner_id=${banner.id}"> <field name="size" column="size" /> </entity> </entity> </entity> </document> </dataConfig> I have defined the following fields in schema.xml: <field name="id" type="string" indexed="true" stored="true" /> <field name="campaign_name" type="string" indexed="true" stored="true" /> <field name="banner_type" type="string" indexed="true" stored="true" multiValued="true" omitNorms="true" termVectors="true" /> <field name="size" type="string" indexed="true" stored="true" multiValued="true" omitNorms="true" termVectors="true" /> Hope that makes it a bit clearer. Thanks. Kind regards, Nick -- View this message in context: http://www.nabble.com/How-to-search-a-DataImportHandler-solr-index-tp20120698p20149960.html Sent from the Solr - User mailing list archive at Nabble.com.