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.

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

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

Bathinda (Bathinda Helper) Março 5, 2020, 3:46am 7

Isso gera o seguinte erro ao executar:

PG::SyntaxError: ERROR:  erro de sintaxe próximo a "{"
LINE 9: {"query":{"id":12,"sql":"SELECT id, title, user, category_id...
        ^

Tópico		Respostas	Visualizações
Find pinned topic via API endpoint Development rest-api	1	403	1 de Setembro de 2022
Globally pinned topic only appears in one category Support	11	1843	5 de Janeiro de 2022
Pin more than one topic globally Feature pinned-topics	6	336	30 de Maio de 2025
Can't Pin Globally Support	3	463	25 de Julho de 2023
Filter for globally pinned topics Feature topic-filter	0	85	1 de Setembro de 2025

Get list of topics pinned globally

Tópicos relacionados