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.<br>
<br>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.<br><br>I have the following search parameters.<br>
<br>mv_coordinate = 'yes'<br>mv_search_file = 'products'<br>mv_searchtype = 'db'<br>mv_return_fields = 'sku, description, prod_group, category, option_type, manufacturer, comment, rrp, price'<br>
mv_sort_field = 'category, manufacturer, price, description'<br>mv_sort_option = 'f,f,n,f'<br><br>mv_search_field = 'prod_group'<br>mv_column_op = 'rm'<br>mv_search_spec = 'something'<br>
<br>mv_search_field = 'variants:description'<br>
mv_column_op = 'rm'<br>
mv_search_spec = 'something'<br><br>As i said this does not seem to match the desired results the equivalent sql query for this would be:<br><br>SELECT p.sku, p.description, p.prod_group, p.category, p.option_type, p.manufacturer, p.comment, p.rrp, p.price<br>
FROM products AS p, variants AS v<br>WHERE v.sku = p.sku AND p.prod_group LIKE '%something%' AND v.description LIKE '%something%'<br>ORDER BY category, manufacturer, price, description<br><br>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.<br>
<br>Graham<br>