Forum Discussion
The major thing I needed to change in my strategy is that you cannot reference the fields you are querying in Jinja on the query step. You need to query for everything and then have a conditional statement based on all of the records queried. From there you can now use the Expression Boolean fields like I was wanting to. I do suggest splitting your Jinja into many different Expression Boolean fields if you're working on something similar to this because it gives you the ability to troubleshoot if your query isn't giving you the results you were expecting.
I also needed to make a few adjustments to my syntax. Based on his feedback I have been able to successfully implement this design using Pipelines and Jinja. Using Jinja has allowed me to comment out the many different ways a record could match criteria.
I hope this helps someone out there looking to do something similar!
------------------------------
Hannah Wright
------------------------------
i appreciate the feedback and certainly knowing Jinja syntax is a valuable skill set so maybe you did it this way to prove to yourself it can be done in Jinja and to improve your skills.
In this specific use case though, could you have simply built a Boolean field in the Quick Base table and filter in Pipeline where that was true?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- HannahWright25 years agoQrew Trainee
Hi Mark,
For my specific purposes that would not have worked. Criteria don't have to be specific sometimes they could accept "ALL".
For example:
Job: RN vs Job: ALL
One criteria might only apply to RN's but another criteria might apply to any job we place for. This specific or ALL scenario is one that applies to all of the different criteria types I would need to query for. This being said, I would not be able to create a formula field that listed all the possible ways a criteria could match a person and use that in the pipeline. I've attached a picture of the Query I mapped out before writing the Jinja. It was also important I know why a criteria matched the query which using Jinja in Pipelines allowed me to do since I could comment out the scenario that pipelines ran on.
-Hannah Wright
------------------------------
Hannah Wright
------------------------------