• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
Solution home App Resources Google Sheets

Google Sheets: Search by Query

Modified on: Fri, Oct 14, 2016 at 11:18 AM

Search by query


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:

  1. Searching only works for single-word column headers. There must be no spaces in between
    1. Username works, but not User name
  2. Searches are not case-sensitive
    1. Searching for workato will return workato, Workato and WORKATO
  3. Search results are limited to 100 entries returned by the system

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

Related Articles

    Still can't find your solution?

    Visit our forums to search for answers, or post your own questions.

    Documentation
    Developer's Library
    Tutorials
    eBooks
    Product Hour
    Product Blog
    Workato Blog
    Product updates
    Customer Stories
    © Workato 2020   Privacy   Terms   +1 (844) 469-6752
    • Documentation
    • Workato Blog
    • Product Blog
    • Solutions
    • Forums
    • Tickets
    • Log in
    • Return to Workato
    Article views count