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”:
topic_tags tt ON t.id = tt.topic_id
tags tg ON tt.tag_id = tg.id
t.title ILIKE 'D%'
AND tg.name = 'index'
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.