Pipelines Advanced Query

Question

The goal is to build an Advanced Query in a Pipeline that will compare two User Fields in the record.&nbsp; 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.&nbsp;&nbsp;Searching for the syntax to get this right has been fruitless.&nbsp; Anyone know a solution?------------------------------Don LarsonPaasporterWestlake OH------------------------------

donlarson · Answer

Jim,You are correct.&nbsp; The exact syntax and positioning is :However, I did NOT figure it out.&nbsp; Credit goes to Maria in Customer Support.------------------------------Don LarsonPaasporterWestlake OH------------------------------

jimharrison · Answer

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-syntaxJim------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------

donlarson · Answer

Jim,Love the new Avatar.&nbsp; Mr Magoo was hysterical.I just added a vote!------------------------------Don LarsonPaasporterWestlake OH------------------------------

blakeharrison · Answer

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

jakerattner1 · Answer

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

Forum Discussion

Pipelines Advanced Query