Getting Started

 View Only
  • 1.  Documentation on using advanced query in pipeline

    Posted 02-25-2021 01:24
    Where is the documentation on writing the advanced query? I think I need to write an advanced query in search a record(In pipeline) for finding the child records of a parent. Please provide me a link to the documentation.

    ------------------------------
    Aswin Babu
    ------------------------------


  • 2.  RE: Documentation on using advanced query in pipeline

    Posted 02-25-2021 08:06
    One way to learn the syntax is to go to the Parent Record which has an embedded report of the children.  Click on "Full Report" to see the embedded report on a stand alone basis.  Then use the More button and it will have an option to expose the expanded URL.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Documentation on using advanced query in pipeline

    Posted 02-25-2021 18:02
    I just came across this
    https://help.quickbase.com/api-guide/componentsquery.html

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 4.  RE: Documentation on using advanced query in pipeline

    Posted 02-25-2021 18:21
    You should not need to use the Advanced Query section to search for the Child records. If you have the Record ID# of the Parent in your Trigger step, you will just need to create a Search Records step to find the Child records. In this Search Step, you will use the standard Query section at the bottom and set it so that [Related Parent] is equal to {{a.id}}

    ------------------------------
    Blake Harrison
    bharrison@datablender.io
    DataBlender - Quickbase Solution Provider
    Atlanta GA
    404.800.1702 / http://datablender.io/
    ------------------------------