Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
5 years ago

Using API Do_Query within the 'Advanced Query' on a pipeline in 'Search Records'

Hi, I'm trying to use a pipeline to create a bunch of records based on what's returned in a search.  My first step is to use the 'Search' in Pipelines to attempt to return the records I'm looking f...
APIs and custom code
JakeRattner1's avatar
JakeRattner1
Qrew Cadet
5 years ago

Hi Blake, 

For what I'm trying to do I will need to use advanced query.  The query option will not work.  Are you familiar with how to get the do-query to work in advanced query?

The reason is due to the dynamic nature of the filter. I need to be able to use a field in the advance query to which will dynmically build the query and would include several 'and' and 'or' operators.  Unfortunately that isn't possible with the standard query.

Thanks,

Jake



------------------------------
Jake R
------------------------------
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Well, the Advanced Query doesn't need any of the information other than the Query String, but I'm not sure exactly how it needs to be written, other than the basic {fid.comparator.value}. If you need to write something complex, the easier route might be to write that as a formula checkbox field on your table and then do the standard Query on that field.

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
  • JakeRattner1's avatar
    JakeRattner1
    Qrew Cadet
    5 years ago
    Thanks Blake.  That's an interesting idea.  I think I really just need to see any advanced query used in a pipeline, if any one has an example on hand. I wonder if this is covered anywhere in the help or community.

    ------------------------------
    Jake R
    ------------------------------
    • JakeRattner1's avatar
      JakeRattner1
      Qrew Cadet
      5 years ago
      I think I found the answer to this one. I was vastly over complicting the query.  All that needed to be entered into the 'advanced query' box as {'67'.CT.'CA'}

      ------------------------------
      Jake R
      ------------------------------