List issued labels

[paboum]

I would like to know what labels have been already granted to whom from my instance. AFAIU, Ozone's database already contains a table of subjects with their tags, I would just like to see the labels too.

The specific UX for this is not that much relevant, even a script would do for me. But in the future, a workspace-like panel with list of subjects and buttons/checkboxes allowing to quickly add/remove each label would be the most convenient thing. Limited to admins only perhaps.

[paboum]

I was able to read it directly from database:

select uri, string_agg(val, ' ') from label group by uri;

Then I was able to export a comma-separated list of DID/AT-URIs that I can put into workspace:

select string_agg(uri::text, ',') from label;

[foysalit]

event stream is the other way of getting this. you can filter the events page to show all label events and then adding the subjects to workspace should be pretty quick. however, the pagination here can be kinda annoying since we only allow loading a max of 100 events per page.

[paboum]

If pagination works the same way as in xrpc api, then I'm good with: bluesky-social/atproto#2012 (reply in thread)