[ic] Custom SearchOP

[Tom Tucker]

Kevin Walsh wrote:
> Tom Tucker <tom at ttucker.com> wrote:
>   
>> I am using "Mike Heins' modified foundation demo" from 2003. Added a 
>> column for model to the products table (VARCHAR 64). The abridged 
>> dataset I am searching through looks like this:
>>
>> sku        model  prod_group  Category      
>> ---------  -----  ----------  --------
>> MRD_CD5    65-73  Mustang     RADIO
>> MRD_CD6    65-73  Mustang     RADIO
>> M_5482A    65-66  Mustang     RADIO
>> MRD_103    65-66  Mustang     RADIO
>> MRD_105CD  65-66  Mustang     RADIO
>> MRD_1601   65-66  Mustang     RADIO
>> MRD_1501   65-66  Mustang     RADIO
>> MRD_12000  65-66  Mustang     RADIO
>> MRD_105    65-66  Mustang     RADIO
>> MRD_106    65-66  Mustang     RADIO
>> MRD_106CD  65-66  Mustang     RADIO
>> MRD_S06    65-73  Mustang     RADIO
>> MRD_101    65-66  Mustang     RADIO
>> MRD_107    65-66  Mustang     RADIO
>> MRD_107CD  65-66  Mustang     RADIO
>> MRD_108    65-66  Mustang     RADIO
>> M_5482C    65-73  Mustang     RADIO
>> MRD_S11    65-68  Mustang     RADIO
>> MRD_S12    65-73  Mustang     RADIO
>> M_5486A    65-67  Mustang     RADIO
>> MRD_CD     65-73  Mustang     RADIO
>>
>> But the scan only returns the following skus:
>> MRD_101
>> MRD_103
>> MRD_105
>> MRD_105CD
>> MRD_106
>> MRD_106CD
>> MRD_107
>> MRD_107CD
>> MRD_108
>> MRD_12000
>> MRD_1501
>> MRD_1601
>> M_5482A
>>
>> When I look at the mysql log, I see that an "active != 1" is added to 
>> the query (select * from products  WHERE inactive != 1 AND prod_group = 
>> 'Mustang' AND category = 'RADIO') and then 15 iterative selects over the 
>> 13 skus returned getting the additional product, pricing and inventory data.
>>
>>     
> "WHERE inactive != 1" will be added to the search SQL if you have a
> "HIDE_FIELD inactive" modifier defined for your table.  See here:
>
>     http://www.interchange.rtfm.info/icdocs/Database_reference_guide.html#HIDE_FIELD
>
> Do the missing rows all have their "inactive" column set to "1"?
>
> Heh - that'd be too easy.  Assuming that that is not the case, can you
> show the actual search specification you are submitting.
>
>   
>> Noting in the VENDROOT error.log nor debug.log and nothing in the 
>> CATROOT error.log. Curious that a ::logDebug in the SearchOp shows 
>> nothing in the VENDROOT debug.log.
>>
>>     
> ::logDebug won't be available for use within your (local) SeaarchOp
> code.  Use Debug() instead:
>
>     http://www.interchange.rtfm.info/icdocs/Interchange_Perl_objects.html#Debug
>
>   
>> Sorry to be so verbose
>>
>>     
> Verbose is good.
>
>   
Didn't know about HIDE_Field. Now I do, thanks.

Yeah, I checked early on and inactive is set to '' (empty) for all rows.

Actual scan URL is:
http://www.mydomain.com/scan/co=yes/fi=products/sf=prod_group/se=Mustang/op=eq/sf=model/se=68/op=modelyr/sf=category/se=RADIO/op=eq/tf=category,description

I have Rewrites set to serve all pages through IC for this Virtual Host.

Tom