I'm using a condition on my model that uses a subquery to specify which records I'm pulling. For the subcondition I am trying to use the 'LIKE' operator, but I get a malformed query error. Here are some screenshots:
You have misunderstood how to construct subquery conditions. (But don't worry - I think I see your confusion)
You have put the subquery definition in the property called "Subcondition logic". That is not the right place. Push the new condition icon that appears in the left hand panel to expose a second condition builder.
The subcondition logic property is used to define how multiple subconditions work together. You'd expect a statement like this there: (1 OR 2) AND 3 AND 4