Since we currently don't have a way to search our favorites, I built a SEDE Query to List of Favorites for a UserId that are Tagged with TagName.
The query takes two inputs:
- UserId (int)
- TagName (varchar)
However, I'm having problems doing a substring search on TagName within
SELECT Posts.id as [Post Link], Posts.Tags as [Tagged With] FROM Votes, Posts WHERE (Votes.PostId=Posts.Id) AND (Votes.VoteTypeId = 5) AND (Votes.UserId=##User:int##) AND ('##TagName##' LIKE Posts.Tags);
No matter what I try for values of
##TagName##, I can only find questions with a single tag (see screenshot)...
I have tried queries with the following
<python>(returns favorites that have a single tag: python)
Perhaps I have misunderstood the format of the source, but I haven't figured out a better way to make the
TagName queries. There are a lot of questions with multiple tags, but unless we have a wildcard (or substring) search capability on
Posts.Tags, I'm not sure how we can get the right information.
Should I be able to do a wildcard search on
Posts.Tags in SEDE? If so, how should I modify my existing query?