[ic] Variants table and mv_searchspec

[graham hadgraft]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.icdevgroup.org/pipermail/interchange-users/attachments/20090318/00206f70/attachment.htm