The Query view is the best place to searches and find journeys that have been evaulated by the Darwinium risk decision engine.
Search: Quick start
The search bar filters the rows of data to just those that match your query.
The number of events matching your search criteria is displayed in lower right.
// Simple search
event_type = 'misc_other'
// Most attribute have dots in their name, based on their attribute group
profiling.javascript.os= "Mac OS X"
profiling.javascript.browser= "Firefox"
// Some attributes have CONTEXTs, accessed with [' ']
identity['ACCOUNT'].email['PERSONAL'].email = 'test@test.com'
outcome['CHAMPION'].decision_strategy.result = 'reject'
// Can combine logic; AND, OR, (brackets).
// Logic can be UPPER or lower. Attributes are lower only.
event_type = 'misc_other' OR step_name = 'Login'
// IN can be used to check many values in a list.
// Single or double quotes work for strings.
event_type IN ('account_login_success', "account_login_failed")
// Logical negative is done with NOT or ! character
step_url != "/login"
step_url NOT IN ("/login", "/register")
// Empty attribute values are checked with null keyword
step_url = null
step_url != null
// Empty string attributes can also be searched with
step_url = ''
// Mathematical operators work on numerical attributes
payment.amount >= 10
// Maps eg. feature:value dicts can be accessed with attr['keyvalue']
// Note: This is true of attribute CONTEXTs too.
outcome['CHAMPION'].features.general['cnt_dvcid_for_eml_inc'] != null
outcome['CHAMPION'].features.general['cnt_dvcid_for_eml_inc'] > 2
// Presence in an Array eg. signals can be checked with has function
// Functions are camelCase
has(outcome['CHAMPION'].models.signals, "Device used first time")
!has(outcome['CHAMPION'].models.signals, "Device used first time")
See Darwinium Query Language for full syntax and function reference.
Templates: (Default Query)
You can save how you arrange the graphs and data of your Query or Journey view to a template.
That lets you and/or your team load the consistent view again of:
- search query
- which attributes are loaded in the table
- the ordering of the outer category of data]
- grid palette color rules
Saved searches
The list icon next to timeframe search component remembers your previous searches.
This is an easy way to select and search again for your common queries.
Timeframe
On right hand side of search bar is option to restrict based on timestamp of the event
- Last: will bring in all data from now backwards that amount of time
- Darwinium stores data for a year by default. Contact Darwinium if extended data retention is desired.
Custom: The selectors at the bottom can be used for custom timeframes.
- Selected days are inclusive
- Only day granularity are currently supported
Add new visualisation
The Graphs that appear at the top of the table can be customised.
Tip : Clicking on the edges of these graphs allow them to be moved and resized.
Add new visualisation with the toolbar
Which creates a New Graph panel
Assign a name, icon and graph type:
- Time series: Bar chart
- Time series attribute = partition and color bars by this attribute value
- Device map: count geography map
- Entity relationships: Links between identifiers
Hit save to create the visual.
The gear icon in top right corner of the graphs can be used to access settings again
Grid color view
Rules can be assigned to color datapoints in the table to help visual investigations
See Query Data Table View.
Copy query to Python
The arrow next to the search bar reveals additional options around the search.
Copying the search query as Python will form and copy to your clipboard a query that can be pasted into a Python notebook within Workflows.