Does anyone have an example of using this with SQL Server varchar or XML field?
?? <dataConfig> <dataSource /> <document> <entity name="y" query="select * from y where xid=${x.id}"> <entity name="x" processor="XPathEntityProcessor" forEach="/the/record/xpath" url="${y.xml_name}"> <field column="full_name" xpath="/field/xpath"/> </entity> </entity> </document> </dataConfig> On 2/16/11 2:17 AM, "Stefan Matheis" <matheis.ste...@googlemail.com> wrote: >What about using >http://wiki.apache.org/solr/DataImportHandler#XPathEntityProcessor ? > >On Wed, Feb 16, 2011 at 10:08 AM, Bill Bell <billnb...@gmail.com> wrote: >> I am using DIH. >> >> I am trying to take a column in a SQL Server database that returns an >>XML >> string and use Xpath to get data out of it. >> >> I noticed that Xpath works with external files, how do I get it to work >>with >> a database? >> >> I need something like "//insur[5][@name='Blue Cross']" >> >> Thanks. >> >> >>