Is there a way to get list of topics which are pinned globally. In advanced search there is “are pinned” but it does list all pined topics. [image] We wold like to find globally pined topics so we can clear our latest list.

We unfortunately require logins to view any content . I need then dummy account to reuse.

If you have Data Explorer Plugin installed, this should do it. pinned-topics.dcquery.json (213 Bytes)

Thanx for tip here is corrected version for others. Added pinned_globally=TRUE in where clue SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE {"query":{"id":12,"sql":"SELECT id, title, user, category_id ,pinned_globally FROM topics WHERE pinned_at IS NOT NULL and pinned_globally=TRUE","name":"Pinned Topics","description":"Enter a description here","param_info":[]}}

Note in:pinned should find all pinned topics be they globally or locally pinned.

This gives this error when ran: PG::SyntaxError: ERROR: syntax error at or near "{" LINE 9: {"query":{"id":12,"sql":"SELECT id, title, user, category_id... ^

Here is an updated Data Explorer query which returns a tidier list of all pinned posts by category, with globally pinned topics at the top: SELECT pinned_globally, TO_CHAR(pinned_until,'DD/MM/YYYY') as pinned_till, id as topic_id, user_id, category_id FROM topics WHERE deleted_at IS NULL AND pinned_at IS NOT NULL AND (pinned_until IS NULL OR pinned_until > CURRENT_TIMESTAMP) ORDER BY pinned_globally desc, category_id

Get list of topics pinned globally

Community Building Data & reporting

codinghorror (Jeff Atwood) August 29, 2017, 11:37am 2

The usual way is to view the site in incognito mode in your browser.

Topic		Replies	Views
Find pinned topic via API endpoint Development rest-api	1	418	September 1, 2022
Globally pinned topic only appears in one category Product Support	11	1914	January 5, 2022
Pin more than one topic globally Feature pinned-topics	6	365	May 30, 2025
Can't Pin Globally Product Support	3	486	July 25, 2023
Filter for globally pinned topics Feature topic-filter	0	90	September 1, 2025

Get list of topics pinned globally

Related topics