[ic] Get ActionMap to search 2 fields?

[Peter]

On 09/23/2009 06:58 AM, IC wrote:
>> The problem is you're using a coordinated and search for inactive and
>> prod_group and trying to combine it with an or search for category2 or
>> category.  Interchange is not able to do this the way you want.
>>
>>
>> Peter
> 
> Thanks Peter, I have now had to modify the actionmap for a non-coordinated
> search:-
> 
>     $CGI->{mv_coordinate} = 'no';
>     $CGI->{mv_substring_match} = 'yes';
>     $CGI->{mv_search_file} = 'products';
>     $CGI->{mv_return_fields} = 'sku,sale_price';
>     $CGI->{mv_search_field} = "category,category2";
>     $CGI->{mv_searchspec} = "$category";   
>     $CGI->{mv_column_op} = "rm";
> 
> This works but shows inactive products, to get around this I have had to
> modify the results page with:-
> 
> [search-list]
> [if-item-field inactive != 1]
> 
> Display product...
> 
> [/if-item-field]					
> [/search-list]
> 
> Which again works ok, anyone have a better solution?

Yep, put this in your products.mysql (or products.pgsql) file:

Database  products  HIDE_FIELD   inactive


Peter