Skip to main content
Question

Pipelines Advanced Query

  • April 29, 2021
  • 0 replies
  • 890 views
Forum|alt.badge.img+15
The goal is to build an Advanced Query in a Pipeline that will compare two User Fields in the record.  I am looking for the Record Owner to match the User in FID 9.

The query that will not work is

  • {'4'.EX.'9'}
What the query says is Record Owner equals 9 not the value of the User in FID 9.  

Searching for the syntax to get this right has been fruitless.  Anyone know a solution?


------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------

    JimHarrison
    Forum|alt.badge.img+18
    • JimHarrison
    • Registered
    • April 29, 2021
    Don,

    I am amazed! Don't do much with Pipelines yet. Thought I'd go in to try out an idea and this is the first problem I ran into from the start. So I made this in case anyone else wants to Vote.

    https://quickbase.uservoice.com/forums/111823-quickbase-product-feedback/suggestions/43317924-pipelines-advanced-query-syntax

    Jim

    ------------------------------
    Jim Harrison
    transparency = knowledge + understanding : The Scrum Dudes
    ------------------------------
    You could try building an Expression in the standard Query section. I was able to do this to limit the run-time of a Pipeline to a little more than office hours:



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