Lookup object with & in the name

Question

Is anyone using the lookup object in an automation were the value includes & in it? I have an automation that is looking up approvers based in the department, and one of our departments has an & in its name and the lookup fails if I reference the custom field in the query. But if I manually enter the department name in the query it says the syntax is valid.

Bill Sheboy · Answer

Thanks!  I missed finding that one in my searches as I was checking the wrong projects  :^)

Mikael Sandberg · Answer

Turns out this is a bug, JSDCLOUD-11142 - Looking up Insight objects in automation when the IQL contains an & throws an error and returns no results

Bill Sheboy · Answer

I just did a quick look in the Automation Cloud and the old Code Barrel backlogs and did not see this symptom.