Most Recent Messages Summary

LabKey Support Forum (Inactive)
Most Recent Messages Summary martin  2014-10-30 05:48
Status: Closed
 
Hi, I was wondering, is there a way to display the most recent messages from message boards from all folders and subfolders in a project?

(Or from all projects on a labkey server?)

What is the schema the messages are stored in? Is it accessible by querying?

Thanks for your response
Martin
 
 
adam responded:  2014-10-30 08:06
Messages are exposed in the "announcement" query schema, making this data available for all standard query operations (grid views, export, API access, etc.). For example, you can view the query version of this forum, ordered from most recent message, via this URL:

https://www.labkey.org/query/home/Developer/Forum/executeQuery.view?schemaName=announcement&query.queryName=Announcement&query.sort=-Created

By applying the folder filter "Current folder and subfolders" the grid will include messages from all subfolders where the user has read permissions. You can also query subfolders programmatically using the containerFilter config option on selectRows().

You probably want to activate the "Messages" module in the folders where you perform these queries, otherwise the schema will be hidden.

Adam