Query is a tool that allows to find certain data by filtering by specific criteria. You can easily define complex search functions through the Query analysis tool using a simple point-and-click configuration. The program will find timelines that match the set conditions with sub-second response time.
The Query tool allows you to quickly and easily define complex searches based on events, their attributes, event ordering, time gaps, as well as including events that failed to happen.
Configure and perform Query search
- Open a Query form
Find the icon in the right menu and click on it.
- Set events
Click on an empty pattern block to add events. If needed, you can then click Set events on the right to modify the set of added events.
Note. If you added several events in one block, further settings will be applied to all the events included in the block and shown within the block frame.
- Set the event occurrence
Choose Has to happen option if you want to include the event into search result obligatorily or Should not happen to exclude. You can also set minimum or maximum number of the event occurrence for a more precise filtering by defining At least or Less than values.
- Configure the Event attributes
Choose Operator from a drop-down list for the needed attribute, then fill the Value fields. Operator options may vary depending on the attribute type: String, Date, Number, Boolean. To clean a field, click .
The following attributes are present by default in any project:
- Time - to filter the events that happened within a certain period: Earlier than or Later than a set date, or Between two set dates.
- Happened from now - to see events that happened within a certain time frame before the Query search is executed: More than or Less than a set time range or Any time from the query creation.
Values input modes
Raw input mode - allows you insert symbols manually. Preferably used when you need a non-exact match, e.g. using Contains operator. By default, all Value fields are in this mode.
Attribute value selection mode - allows you choose a value from a drop-down list, if you need an exact match, e.g. using Equals operator.
You can switch between attribute value selection mode and raw input mode by clicking and correspondingly.
Note. For the first block pattern only the raw input option is possible.
- Configure connections between events
- Click dots between two events to configure connections.
- Select whether other events can happen in between the selected events, or if they need to be directly followed by one another.
- Specify how much time should pass between the connected events.
- If needed, you can also insert a new event between selected ones by clicking on + add event.
- Save query
Click Save to be able to use this query configuration in the future.
- Execute search
Click Search to filter the timelines.
As an example, let's take a call center. You are a manager who wants to analyze the workflow to see if it meets the following condition: every request should be closed only after approval. You can create a query to learn if some requests were closed without approval, and how many such requests are there.
- Open a Query form.
- Add the CLOSE event in a pattern block, that represents the action of closing a request.
- To ignore all timelines where this event does not happen, make sure the option Has to happen is checked.
- To search for all timelines where requests were closed without approval, find the Event attribute in the list that represents the approval. Set its Operator to is (available for number and boolean event types) and Value to false.
The specified settings will be shown in the pattern block as well.
- Click Save as and enter the name for your query, so you won't need to configure it again.
- Click Search. You will see the Overview page with the Query filter applied. You can see the number of timelines that meet the search conditions in the Current filter.
11/30/2022 4:35:57 AM