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) 2017 年 8 月 29 日午前 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	2022 年 9 月 1 日
Globally pinned topic only appears in one category Support	11	1842	2022 年 1 月 5 日
Pin more than one topic globally Feature pinned-topics	6	336	2025 年 5 月 30 日
Can't Pin Globally Support	3	462	2023 年 7 月 25 日
Filter for globally pinned topics Feature topic-filter	0	85	2025 年 9 月 1 日

Get list of topics pinned globally

関連トピック