[ic] Variants table and mv_searchspec

[ic at 3edge.com]

graham hadgraft writes: 

> Im having trouble trying to perform a search.  Im creating a search and i
> need to do to clauses where products.description LIKE '%something%' and
> variants.description LIKE '%something%'.  Im using the search-region and
> mv_searchspec parameters but i cant seem to get it to perform the search. 
> 
> As far as i can tell from the interchange docs you suppose to reference
> another table using the format table:field in the mv_search_fields parameter
> but it does not seem to be searching using this. 
> 
> I have the following search parameters. 
> 
> mv_coordinate = 'yes'
> mv_search_file = 'products'
> mv_searchtype = 'db'
> mv_return_fields = 'sku, description, prod_group, category, option_type,
> manufacturer, comment, rrp, price'
> mv_sort_field = 'category, manufacturer, price, description'
> mv_sort_option = 'f,f,n,f' 
> 
> mv_search_field = 'prod_group'
> mv_column_op = 'rm'
> mv_search_spec = 'something' 
> 
> mv_search_field = 'variants:description'
> mv_column_op = 'rm'
> mv_search_spec = 'something' 
> 
> As i said this does not seem to match the desired results the equivalent sql
> query for this would be: 
> 
> SELECT p.sku, p.description, p.prod_group, p.category, p.option_type,
> p.manufacturer, p.comment, p.rrp, p.price
> FROM products AS p, variants AS v
> WHERE v.sku = p.sku AND p.prod_group LIKE '%something%' AND v.description
> LIKE '%something%'
> ORDER BY category, manufacturer, price, description 
> 
> Unfortunatly for certain resons i can not use  query i have to uise the
> search-region. What is wrong with the search parameters i am adding. 
> 
> Graham

Did you look at mv_like_field (lf)  and mv_like_spec (ls)  ? 

CU, 

Gert