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 top…

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 pinn…

Get list of topics pinned globally

Community Building Data & reporting

codinghorror (Jeff Atwood) 8월 29, 2017, 11:37오전 2

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

글		댓글	조회수
Find pinned topic via API endpoint Development rest-api	1	403	9월 1, 2022
Globally pinned topic only appears in one category Support	11	1843	1월 5, 2022
Pin more than one topic globally Feature pinned-topics	6	336	5월 30, 2025
Can't Pin Globally Support	3	463	7월 25, 2023
Filter for globally pinned topics Feature topic-filter	0	85	9월 1, 2025

Get list of topics pinned globally

Related topics