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
BlakeHarrison's avatar
BlakeHarrison
Qrew Captain
5 years ago
Jake -

Using the Advanced Query is unnecessary for what you're trying to accomplish. You'll need to use the standard Query option at the bottom of this form like this:



------------------------------
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

    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
        ------------------------------