[ic] Actionmap 2 table problem

[Peter]

On 27/06/12 23:04, Peter wrote:
> Right, because mv_coordinate is set, the first set of search params
> looks like: products:inactive ne 1
> ...and the second looks like: products2:description rm $w1
> 
> You can do this with an IC search, but you really are much better off
> using an SQL query like racke suggests.

Just to be clear, if you really want to go the IC search route do it
like this:

$CGI->{mv_todo} = 'search';
$CGI->{mv_nextpage} = $Config->{SpecialPage}->{results};
$CGI->{mv_searchtype} = 'db';
$CGI->{mv_coordinate} = 'yes';
$CGI->{mv_substring_match} = 'yes';
$CGI->{mv_search_page} = 'results';

$CGI->{mv_search_file} = 'products,products2';
$CGI->{mv_search_field} = 'description';
$CGI->{mv_searchspec} = $w1;
$CGI->{mv_column_op} = 'rm';

$CGI->{mv_matchlimit} = '15';
$CGI->{mv_sort_field} = 'sale_price';
$CGI->{mv_sort_option} = 'n';

...and make sure that HIDE_FIELD is set properly in your database config
files:
http://interchange.rtfm.info/icdocs/Database_reference_guide.html#HIDE_FIELD


Peter