Another thing I don't get. The system feels like it's doing the extra
queries. I put the LogTransformer expecting to see additional output on one
of the child entities
<entity name="section_product" query="select section_title as sections from
section s, section_product sp where sp.section_id = s.section_id and
sp.product_id='${product.product_id}'"
transformer="LogTransformer" logTemplate="Section title is:
${section_product.sections}" logLevel="debug"/>
And yet there is no additional output.
Thanks,
John
On Mon, Mar 8, 2010 at 11:37 AM, John Ament <my.repr...@gmail.com> wrote:
> Erick,
>
> I'm sorry, but it's not helping much. I don't see anything on the admin
> screen that allows me to browse my index. Even using Luke, my assumption is
> that it's not loading correctly in the index. What parameters can I change
> in the logs to make it print out more information? I want to see what the
> query is returning I guess.
>
> Thanks,
>
> John
>
>
> On Mon, Mar 8, 2010 at 11:23 AM, Erick Erickson
> <erickerick...@gmail.com>wrote:
>
>> Try http://<localhost address and port>/solr/admin. You'll see a bunch
>> of links that'll allow you to examine many aspects of your installation.
>>
>> Additionally, get a copy of Luke (Google Lucene Luke) and point it at
>> your index for a detailed look at the index.
>>
>> Finally, the SOLR log file might give you some clues...
>>
>> HTH
>> Erick
>>
>> On Mon, Mar 8, 2010 at 10:49 AM, John Ament <my.repr...@gmail.com> wrote:
>>
>> > Where would I see this? I do believe the fields are not ending up in the
>> > index.
>> >
>> > Thanks
>> >
>> > John
>> >
>> > On Mon, Mar 8, 2010 at 10:34 AM, Erick Erickson <
>> erickerick...@gmail.com
>> > >wrote:
>> >
>> > > What does the solr admin page show you is actually in your index?
>> > >
>> > > Luke will also help.
>> > >
>> > > Erick
>> > >
>> > > On Mon, Mar 8, 2010 at 10:06 AM, John Ament <my.repr...@gmail.com>
>> > wrote:
>> > >
>> > > > All,
>> > > >
>> > > > So I think I have my first issue figured out, need to add terms to
>> the
>> > > > default search. That's fine.
>> > > >
>> > > > New issue is that I'm trying to load child entities in with my
>> entity.
>> > > >
>> > > > I added the appropriate fields to solrconfig.xml
>> > > >
>> > > > <field name="sections" type="string" indexed="true" stored="true"
>> > > > multiValued="true"/>
>> > > > <field name="colors" type="string" indexed="true" stored="true"
>> > > > multiValued="true"/>
>> > > > <field name="sizes" type="string" indexed="true" stored="true"
>> > > > multiValued="true"/>
>> > > >
>> > > > And I updated my document to match
>> > > >
>> > > > <document>
>> > > > <entity name="product" query="select product_id, product_id
>> as
>> > > > id,vendor_label_name, sku2,
>> > > style,product_name,delivery_time,regular_price,
>> > > > copy_field,bullet1,bullet2,bullet3,bullet4,bullet5,bullet6,
>> > > > bullet7,bullet8,bullet9,bullet10,bullet11,bullet12 from product_v
>> where
>> > > > status_code = 'ACTV' and regular_master_variant in (2,1)">
>> > > > <entity name="section_product" query="select
>> section_title
>> > as
>> > > > sections from section s, section_product sp where sp.section_id =
>> > > > s.section_id and sp.product_id='${product.product_id}'"/>
>> > > > <entity name="color_product" query="select distinct
>> > > > aev.enum_value as colors from product_attribute_enum
>> > > > pae,attribute_enum_value aev, sub_product sp where pae.product_id =
>> > > > sp.sub_product_id and pae.attribute_type_id = aev.attribute_type_id
>> and
>> > > > pae.attribute_value_id = aev.attribute_value_id and
>> > pae.attribute_type_id
>> > > =
>> > > > 107 and sp.master_product_id = '${product.product_id}'"/>
>> > > > <entity name="size_product" query="select distinct
>> > > > aev.enum_value as sizes from product_attribute_enum
>> > > > pae,attribute_enum_value
>> > > > aev, sub_product sp where pae.product_id = sp.sub_product_id and
>> > > > pae.attribute_type_id = aev.attribute_type_id and
>> > pae.attribute_value_id
>> > > =
>> > > > aev.attribute_value_id and pae.attribute_type_id = 108 and
>> > > > sp.master_product_id = '${product.product_id}'"/>
>> > > > </entity>
>> > > > </document>
>> > > >
>> > > > So my expectation is that there will be 3 new fields associated with
>> it
>> > > > that
>> > > > are multivalued: sizes, colors, and sections.
>> > > >
>> > > > The full-import seems to work correctly. I get the appropriate
>> number
>> > of
>> > > > documents in my searches. However, sizes, colors and sections all
>> come
>> > > up
>> > > > null (well, I should say they don't come up when I search for them).
>> > > >
>> > > > Any ideas on why it won't load these 3 child entities?
>> > > >
>> > > > Thanks!
>> > > >
>> > > > John
>> > > >
>> > >
>> >
>>
>
>
