I was able to alter code from the “Understanding User Defined Methods” video from Epicor University to do this. An example is below. It returns only CustID’s that contain “5”:
return string.Join(“~”, (from custRow in Db.Customer where custRow.CustID.Contains(“5”) == true select custRow.CustID).ToArray());
This type of code works with other database tables. I was able to change the table to PcConData (and change the field names) and get similar code to work. The code without the where clause would return all CustIDs in the database. The where clause limits it to CustIDs containing “5”. Contains function is sweet, used link below for documentation on it:
I’m still waiting to hear back from Support whether you’re supposed to be able to do this thru BAQ. I’ll update this thread when I hear back. If BAQs are supposed to work and support can help me figure out how, I’ll also ask them which method is better for system performance and respond to this thread. But the above is definitely a working solution.