Miva Merchant 4 Module FAQs » Order Status (BROK_ORDERSTATUS)


{docurl}

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.)



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

Print this record Send FAQ to a friend Show this as PDF file
Please rate this FAQ:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry

Records in this category