Miva Merchant 4 Module FAQs » Generic Order Export (BROK_GENEXPORT)

"order filter" and "item filter" Field Uses

These fields permit very sophisticated filtering of the export.

The text in the fields (if any) are the actual filter used to filter the orders and orderitems (respectively) databases. If they are left empty, no filtering will be done.

So you can enter a filter statement into these fields that will limit the orders exported. The filter statements take tokens to represent the various order and item data; the same tokesn used to display those fields in the templates.

For example, to filter the order data for a particular order id you could use the filter:

('1000' IN %orderid%)

This will export ONLY order id 1000.

Note that the value to be searched for has to be in single quotes and the whole thing should be enclosed in parentheses). Another example, to search for a range of orders:

((%orderid% LT '1020') AND (%orderid% GT '1000'))

will result in all orders with id less than 1020 and greater than 1000 being export. The comparison operators are those available in standard Miva script (You can go here: http://www.miva.com/docs/ScriptMan_html/04-Operators.html#468771 for more details):

GT greater than
LT less than
EQ equal to
NE not equal to
GE greater than or equal to
LE less than or equal to

Filters can also contain the logical operators:

NOT
AND
OR

As well as the string operators:

$
IN/CIN
EIN/ECIN
SUBSTR

411/16%Last update: 2003-07-30 01:05
Author: Support
Revision: 1.0

Please rate this entry:

Average rating: 0 out of 5 (0 Votes )

completely useless 1 2 3 4 5 most valuable

You cannot comment on this entry