Hey everyone, first off thanks for the help on this one. So I have attached a screen shot of a data sample we are trying to query. This budgetgroup contains a couple fields which references a user object Id. The fields are: budgetOwner (single user Object Id), approvers (array of user object ids), and members (array of user objectIds). I am trying to develop a single database query that will return an array of budget groups in which contain a specific user object ID in either the budgetOwner field, or within the two arrays (approvers & members).
Any help on this one would be greatly appreciated.