Building an Index from topics

Feature
1

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.

2 Likes
2

I think that you can achieve that with the experimental filter functionality: