This query works for me on the Task object. I am able to show WhoId as field
select id, subject, WhoId, Who.name, who. createddate from task where owner.id ='0056F00000DWfjYQAT' and subject like 'outbound%'order by createddate desc
However wanted to narrow it down further by using the WhoId as a WHERE clause but that didn't work. I tried
select id, subject, WhoId, Who.name, who. createddate from task where owner.id ='0056F00000DWfjYQAT' and subject like 'outbound%' and whoid like '00Q%'order by createddate desc
This is the error message I got
invalid operator on id field
Would like to understand why I can't do that? How can I rewrite my query to narrow down my search?
Thank you