Does anyone know how to query staff notes notices from the database? I’ve been looking around in the code but haven’t been able to find where they are stored. My main goal is to find a specific staff notice that was written in the past week, so I’m looking for a way to skim through the recent custo…

It should be in the custom fields like you’ve mentioned app/controllers/posts_controller.rb e90aac11c def notice raise Discourse::NotFound unless guardian.is_staff? post = find_post_from_params if params…

Thanks, I’m looking for “staff notices” (core feature), which I think is different from “user notes” (separate plugin). I might be confused though. :slight_smile: The item named “Add Staff Notice”: [image]

Thanks. In case anyone else is looking for a quick way to skim the data, this works in the Rails console: results = Post.all.reject { |p| p.custom_fields['notice_type'].nil? } results.each do |r| puts r.custom_fields end Sample output: {"notice_type"=>"returning_user", "notice_args"=>"2018-08-…

Where are staff notices stored in the database?

Product Support

tgxworld (Alan Tan) August 7, 2019, 8:53am 2

PlugintStoreRow.where(plugin_name: "user_notes") is probably what you’re looking for

Topic		Replies	Views
Is it possible to view all staff notices? Product Support post-notices	2	285	June 19, 2021
Discourse-user-notes API Development user-notes , rest-api	3	1035	October 21, 2022
Check who put a staff note Product Support post-notices	1	251	February 28, 2024
Staff Notices for....staff? Product Support	3	1191	November 9, 2022
Staff notices on specific user Product Support	4	1833	April 26, 2019

Where are staff notices stored in the database?

Related topics