Finding approvals based on custom Approver field

[Huyen Huynh]

I've defined 2 custom fields for approvers (Budget Approver, Tech Approver) and 2 custom fields to store approval states (Budget Approval, Tech Approval - each field can be set to "not applicable", "approved", "pending").  The approver custom fields will contain variable values.

When an issue is approved by either Budget Approver or Tech Approver, I want to set their respective Budget Approval and Tech Approval fields to "approved".

I can query for these issues using "Approvals = approver("user")"; however, since Budget or Tech Approver will be variable, how can I find these issues since the approvals query doesn't allow me to pass in the custom Approver field?