[ic] Get ActionMap to search 2 fields?
Peter
peter at pajamian.dhs.org
Thu Sep 24 00:20:22 UTC 2009
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
More information about the interchange-users
mailing list