Re: Query LIKE filter triggering error

Hi Tiana, You need to escape the square braces using []. []] : matches the single character ']' [[] : matches the single character '[' Let me know if that works for you. Cheers, Anash ref:_00D1U1174p._5004Q2PIaQw:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our

Re: Query LIKE filter triggering error

Hi Tiana, Thank you for the follow up question. Allow me to discuss it to the team and we will get back to you with an answer. Regards, Ernie John Blanca Tacata Google Ads API Team ref:_00D1U1174p._5004Q2PIaQw:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blo

Re: Query LIKE filter triggering error

Hi Ernie, Thanks for looking into this! Removing the [ works for the request but is it by design that special characters aren't supported in a LIKE operator's filter values? Best, Tiana On Wednesday, 13 October 2021 at 07:11:00 UTC+2 adsapi wrote: > Hi Tiana, > > Thank you for providing t

Re: Query LIKE filter triggering error

Hi Tiana, Thank you for providing the requested details privately. Let me reply here on this forum post for the benefit of the other advertisers that will encounter the same issue. Upon impersonating the report on my end, I was able to replicate the issue. With this, I tried modifying the quer

Re: Query LIKE filter triggering error

Hi Peter, Thanks for getting back to me! I sent the requested information privately. Best, Tiana On Tuesday, 12 October 2021 at 05:08:10 UTC+2 adsapi wrote: > Hi Tiana, > > Thank you for reaching out. > > So that I can take a closer look, could you also share the complete > request >

RE: Query LIKE filter triggering error

Hi Tiana, Thank you for reaching out. So that I can take a closer look, could you also share the complete request and response logs, with the request-id, generated when the error occurred? If you haven't yet, logging can be enabled by navigating to the Client libraries > Your client library (e

Query LIKE filter triggering error

Hi there, Question about the LIKE operator for filters. I have the following query: SELECT metrics.clicks FROM campaign WHERE metrics.impressions > 0 AND campaign.name LIKE "%Gene[%" AND segments.date >= '2021-09-01' AND segments.date <= '2021-09-30' When I put that query into the Query genera