Pipelines Advanced Query
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 ...
Forum Discussion
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/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quickbase Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Maybe try something like
{'9'.EX.'Record Owner'}
I have a pipeline using a query with similar syntax, but its looking at a different table. Hope this helps. I'm a little ignorant about queries so its a shot in te dark
------------------------------
Jake R
------------------------------
{'9'.EX.'Record Owner'}
I have a pipeline using a query with similar syntax, but its looking at a different table. Hope this helps. I'm a little ignorant about queries so its a shot in te dark
------------------------------
Jake R
------------------------------
- I tried the following and none produced any results.
{'fid'OBF'today'}
'fid'OBF'today'
'fid'OBF'today()'
'fid'OBF'now()'
'fid'OBF'now'
'fid'OBF'04-30-2021'
{'fid'OBF'04-30-2021'}
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------- Werps, totally missed the dots. I'll try again later.
------------------------------
Jim Harrison
transparency = knowledge + understanding : The Scrum Dudes
------------------------------- So I have been beating on this. Here is a screen shot of the query which fails
I have tried all of these as the arguments for the expression
{{a.employee.id}}
{a.employee.id}
{{employee.id}}
{employee.id}
a.employee.id
'a.employee.id'
'employee.id'
"a.employee.id"
"employee.id"
employee.id
So far none of them have worked.
------------------------------
Don Larson
Paasporter
Westlake OH
------------------------------
