User-posted code blocks in a category

data & reporting
4

You can also extend it to handle a user list version as well if you want to have multiple. eg:

-- [params]
-- user_list :users

SELECT 
    id AS user_id,
    created_at 
FROM users 
WHERE id IN (:users)

There’s a bit more info about some of the other magic parameters here - Utilizing Parameters in Data Explorer Queries

There is a category_id and group_id parameter though they’re not as swish as the user_id one where you get a selection box (they work by typing in the name and it magically converts it to the id). They can be quite useful still, though.

(Also, another generally useful bit of info that can help refine some of the AI-assisted queries is Common Discourse data tips)

1 Like