Skip to content

Add message count to aggregate fetch, add message source text

Elliottetzkorn requested to merge T381402 into main

Closes T381402 Closes T381403

This adds count to the aggregate fetch.

It also adds the message source, and the message reply text to the individual csv generation. In order to do this I am taking a pretty new approach to how we handle metrics:

  • Instead of relying on Slack and Discord's api's to perform followup requests for message data, I am instead just accessing that data in our local db, as a source of truth
  • In order to do this I am just storing the message id, for slack and discord, in the reactions table and nothing more
  • In the query to fetch individual rows for the analytics csv, the reactions table then is being joined to the messages table
  • The messages table now stores more information, including the response that was sent to the platform
  • In order to store the response from the platform, I am awaiting the result of "send" for discord and "say" for slack, in order to store the correct data for later joins
Edited by Elliottetzkorn

Merge request reports