$filter method works perfectly on regular text columns, but I can't figure out how to use it with a "Hyperlink or Picture" type column. For example:
This query is meant to get all the items in the Sponsors list where Target_URL contains the given string. Target_URL is a "Hyperlink or Picture" type column. But it doesn't work.