We’d like to build an “A-Z” index page for all topics with a specific tag. In the data explorer the query would be something like this for the letter “D” and the tag “index”:
SELECT t.id, t.title, t.created_at FROM topics t JOIN topic_tags tt ON t.id = tt.topic_id JOIN tags tg ON tt.tag_id = tg.id WHERE t.title ILIKE 'D%' AND tg.name = 'index' ORDER BY t.title ASC; -- Order alphabetically by title in ascending order
Is there a way to achieve this within the common search, so I may use it in a post as an URL? The query
in:title D% for example returns all topics with “D” somewhere in the title - not only at the beginning of the title.