I have a content type of RFP that has a term reference field named "RFP Categories". The users also have this same term reference. When I publish a node, I want to email all users who selected a category that is tagged in the node.
This SE post (Email users on node creation based on taxonomy reference) comes very close to the answer I am looking for, but I'm not quite able to follow it. I believe in their case they are setting the 'value' to a specific taxonomy term, whereas I need to fetch any use who has a term matching the node's terms.
My rule has the Fetch Entity by Property action seen below. Unfortunately, I cannot see (or maybe I'm failing to understand) how to link the "RFP Category" terms in the node to the terms in the user entities. It is broken somehow because when I publish an RFP node, I get a SQLSTATE error.
This is what my rule looks like so far.