[ic] Help with Form Search and Inactive Tag

[Peter]

On 08/30/2008 11:26 AM, Gert van der Spoel wrote:
>> -----Original Message-----
>> From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
>> users-bounces at icdevgroup.org] On Behalf Of Gary Norton
>> Sent: zaterdag 30 augustus 2008 19:49
>> To: interchange-users at icdevgroup.org
>> Subject: Re: [ic] Help with Form Search and Inactive Tag
>>
>>>> <form action="[area search]" method=post>
>>>> 	<input type=hidden name=mv_session_id value="[data session id]">
>>>> 	<input type=hidden name=mv_searchtype value=db>
>>>> 	<input type=hidden name=mv_matchlimit value=10>
>>>> 	<input type=hidden name=mv_coordinate value=1>
>>>>
>>>> 	<input type=hidden name=mv_search_field	value=inactive>
>>>> 	<input type=hidden name=mv_search_spec value=1>
>>>> 	<input type=hidden name=mv_column_op value=ne>
>>>> 	<input type=hidden name=mv_numeric value=0>
>>>>
>>>> It is not respecting the Inactive filter. Can anyone shed some
>>> insight?
>>> Hi Gary,
>>>
>>> I believe you have a typo. Try using mv_searchspec instead of
>>> mv_search_spec.
>>>
>>> <input type=hidden name=mv_searchspec value=1>
>>>
>> Chris, thanks for spotting that. I must have missed it when trying
>> different options. However, even when fixing the typo, the problem
>> still
>> exists.
> 
> Did you clear your cache after fixing the typo? Refresh refresh, kill
> browser, reinstall Windows .. all that stuff? ;)
> I copied your code and tested it on a clean IC standard store install,
> flipped inactive yes/no for some products and it gave different results.. 
> 
> So this code works .. perhaps you broke something else?
> Happy hunting!

A clean IC standard store install has this in products.mysql (and pgsql):

Database  products  HIDE_FIELD   inactive

... so it would work anyways, regardless of whether the search is 
filtering out inactive or not.

Incidentally, that is probably a better solution for you, to drop your 
inactive stuff from the search and set the field as HIDE_FIELD as per above.

Peter