Basic and advanced searches both require specific syntax to generate optimal results. The following table displays the input types accepted by each available search field.
Note
The following characters are not accepted in search strings: ! > < { } ~ ? & & || = ^
|
Search Type |
Search Field Name |
Type of Term |
Input Type or Prefix Syntax |
|
Basic, no prefix |
Transaction ID |
transaction_id |
string |
|
Basic, no prefix |
Website Name |
site_id |
string |
|
Basic, no prefix |
Order Number |
order_number |
string |
|
Basic, no prefix |
First and Last Name |
name |
string |
|
Basic, no prefix |
Hashed Card Value |
card |
string |
|
Basic, no prefix |
Ship to Email Address |
ship_to_email |
string |
|
Basic, no prefix |
IP Address |
ipad |
ip |
|
Basic, no prefix |
Email Address |
|
string. i.e., abc@email.com |
|
Basic, no prefix |
Customer ID |
uniq |
string |
|
Basic, no prefix |
Transaction Date |
transaction_date |
date |
|
Advanced with prefix |
Agent Assigned to Order |
agent_name |
agent_name:admin |
|
Advanced with prefix |
First Line of Address (use quotes) |
billing_address.address1 |
billing_address.address1: "123 Green Tea Ln" |
|
Advanced with prefix |
Second Line of Address (use quotes) |
billing_address.address2 |
billing_address.address2: "123 Green Tea Ln" |
|
Advanced with prefix |
City name for Billing or Shipping Address (use quotes) |
billing_address.address.city |
billing_address.city: ”San Diego” |
|
Advanced with prefix |
State name for Billing or Shipping Address |
billing_address.address.state |
billing_address.state:AL |
|
Advanced with prefix |
Postal Code value for Billing or Shipping Address |
billing_address.postal_code |
billing_address.postal_code: 30069 |
|
Advanced with prefix |
First Line of Address (use quotes) |
shipping_address.address1 |
shipping_address.address1: "123 Green Tea Ln" |
|
Advanced with prefix |
Second Line of Address (use quotes) |
shipping_address.address2 |
shipping_address.address2: "123 Green Tea Ln" |
|
Advanced with prefix |
City name for Billing or Shipping Address |
shipping_address.address.city |
shipping_address.city:”San Diego” |
|
Advanced with prefix |
State name for Billing or Shipping Address |
shipping_address.address.state |
shipping_address.state:AL |
|
Advanced with prefix |
Postal Code value for Billing or Shipping Address |
shipping_address.postal_code |
shipping_address. address.postal_code: 30069 |
|
Advanced with prefix |
Billing Phone Number |
billing_phone |
billing_phone:2084893354 |
|
Advanced with prefix |
BIN plus four |
bin_plus_four |
bin_plus_four:123456-7890 |
|
Advanced with prefix |
Brand of Payment Type |
brand |
brand:visas |
|
Advanced with prefix |
Enabled = true; Disabled = false |
cookies |
cookies:true |
|
Advanced with prefix |
Device Country Code |
device_country |
device_country:US Country abbreviation is case-sensitive and must be capitalized. |
|
Advanced with prefix |
Device Fingerprint value |
device_id |
device_id: 6158A6B3924670A32D AD65BBC41BD95 |
|
Advanced with prefix |
Email value |
|
email: "janedoe@example.com" |
|
Advanced with prefix |
Enabled = true; Disabled = false |
flash |
flash:false |
|
Advanced with prefix |
GEOX Country Code |
geox |
geox:US Country abbreviation is case-sensitive and must be capitalized. |
|
Advanced with prefix |
IP Addresses are formatted using dotted quad value |
ipad |
ipad:10.0.0.1 |
|
Advanced with prefix |
Enabled = true; Disabled = false |
javascript |
javascript:true |
|
Advanced with prefix |
Enabled = true; Disabled = false |
mobile_device |
mobile_device:true |
|
Advanced with prefix |
Customer Name |
name |
name:"John Doe" |
|
Advanced with prefix |
Automatic Number Identification (ANID) |
anid |
anid:xxxxxxxxxx |
|
Advanced with prefix |
Shipping Phone Number |
shipping_phone |
shipping_phone:xxxxxxxxxx |
|
Advanced with prefix |
Reason Code |
reason_code |
reason_code:searchterm |
|
Advanced with prefix |
Ship to Full Name |
ship_to_name |
ship_to_name:"searchterm" |
|
Advanced with prefix |
Alpha Numeric UDFs |
udfs.value |
udfs.value:searchterm |
|
Advanced with prefix |
Alpha Numeric UDFs (option 2) |
udfs.value.raw |
udfs.value.raw:searchterm |
|
Advanced with prefix |
Persona Network Type |
netw |
netw:A Network type is case-sensitive and must be capitalized. |
|
Advanced with prefix |
Merchant Order Number |
order_number |
order_number:8aa3ba7060 |
|
Advanced with prefix |
PTYP value; CARD, None, etc. |
payment_type |
payment_type:CARD |
|
Advanced with prefix |
Enabled = true; Disabled = false |
proxy |
proxy:false |
|
Advanced with prefix |
Reason Code value |
reason_code |
reason_code:A |
|
Advanced with prefix |
Score value |
score |
score:30 |
|
Advanced with prefix |
Website ID |
site_id |
site_id:fraud |
|
Advanced with prefix |
Shipping Type value |
shipping_type |
shipping_type:2d |
|
Advanced with prefix |
Order Status |
status |
status:A |
|
Advanced with prefix |
Transaction Date, can only be searched explicitly as a range |
transaction_date range |
transaction_date: [07/02/2013 TO 07/03/2013] |
|
Advanced with prefix |
Transaction ID |
transaction_id |
transaction_id: 1PMT0T5C6R5Y |
|
Advanced with prefix |
Velocity Count within 14 days |
velo |
velo:6 |
|
Advanced with prefix |
Velocity Count within 6 hours |
vmax |
vmax:5 |
Comments
0 comments
Article is closed for comments.