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.
! > < { } ~ ? & & || = ^|
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 |
Kount 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 within Kount |
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 |
Kount 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.