|Resolved||• chelsyx||T162178 Fix data retrieval scripts using raw user agent strings|
|Resolved||• chelsyx||T161806 Portal Dashboard: does not display US stats when grouping by region|
This patch fixed the bug in portal/user_agents.R. After the data is backfilled (We should backfill data from March 29), portal dashboard should be able to work again.
There are other scripts in golden that are affected by the raw userAgent strings removal: search/load_times.R, search/app_event_counts.R and portal/app_link_clicks.sql. Since the version of MariaDB we're using doesn’t support JSON functions, and the queries in these scripts can still accomplish the task, I think there is no need to fix them now. @mpopov please let me know if you think otherwise.
Correct! While those scripts/queries do make use of userAgent field, they are not affected by the change. The only truly affected one is portal/user_agents.R Reviewing your patch now, thanks! :)