[ic] Help with Form Search and Inactive Tag
peter at pajamian.dhs.org
Sat Aug 30 23:19:14 UTC 2008
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
>>> Hi Gary,
>>> I believe you have a typo. Try using mv_searchspec instead of
>>> <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
> 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.
More information about the interchange-users