I want to find the most active users in a workspace that are interested in a certain subject eg : Jira.
I thought of either search who is most active in a specific channel or type certain words in chats. Should I use the api, or is there already a tool for this or just a clever query that I have missed?
I have looked into : The search message api method. But I am not sure if it is overkill to write rest client for this use-case.
I guess I am looking for a aggregation method like SQL count by , group by having etc in the Slack Search query language .