Get list of topics pinned globally


(Admir Hodzic) #1

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.

We wold like to find globally pined topics so we can clear our latest list.


(Jeff Atwood) #2

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


(Admir Hodzic) #3

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


(cpradio) #4

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


(Admir Hodzic) #5

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":[]}}