These actions are meant to be used in synergy.
Search by query
The search query should be in this fashion:
age < 30 and height = 180
Compound searches with parentheses and 'or' commands work as well:
(name = "john" and pageviews > 5) or engagementrate > 15
Make sure that your query is correctly set up. It should have the following :
a) Column name in small letters without spacing
b) " " Between your data pill
The first thing you need to do is structure your query.
You can either type it out
Or use Data Pills from other steps of the recipe
Using Data Pills means you can manipulate data for your search query using Formula mode
What this action does is it generates an array (list) of the results in the standard data-pill-accessible format.
Do take note of the following limitations:
Searching only works for single-word column headers. There must be no spaces in between
- Username works, but not User name
Searches are not case-sensitive
- Searching for workato will return workato, Workato and WORKATO
Search results are limited to 100 entries returned by the system