Viking Coders Miva Merchant Module Support and FAQ - Can I limit the search to a particular field in the module's orders database?

Miva Merchant 4 Module FAQs » Order Status (BROK_ORDERSTATUS)

Can I limit the search to a particular field in the module's orders database?

Message

The module has the ability to limit the search to a particular field in the module's Order database. This is accomplished by prepending the search term with the field name, separated by a colon. For example, to search only the "status" field for orders with status "shipped" you would search for:

status:shipped

Similarly, to search for customers with a "shipping last name" of edison you would search for:

ship_lname:edison

If the module does not recognize the portion before the colon as a field in the database it will not limit the search and will instead search for the whole search term as usual.

Here's a list of the fields:

order_id
status
tracknum
tracktype
date
cust_id
login
ship_fname
ship_lname
ship_email
ship_comp
ship_phone
ship_fax
ship_addr
ship_city
ship_state
ship_zip
ship_cntry
bill_fname
bill_lname
bill_email
bill_comp
bill_phone
bill_fax
bill_addr
bill_city
bill_state
bill_zip
bill_cntry
tax
shipping
ship_data (data stored by Merchant for the shipping method)
ship_desc (a description of the shipping method)
pay_data (data stored by Merchant for the payment method)
pay_desc (a description of the payment method)
content (a concatenated list of data about the producs in the order such a name, code, etc.)

283/10%Last update: 2007-11-29 10:53
Author: Thor
Revision: 1.0