Sync issues & status scrutiny

Hi @Anro !

Sorry to hear some CHWs are reporting issues synchronizing. In order to see a report of users that have synchronized, a good way is to use couch2pg. With that set up, you can use this query to show usernames and dates, showing the most recent date first:

select 
  distinct doc#>>'{metadata,user}' as user, 
  concat_ws(
       '-',
       doc#>>'{metadata,year}',
       doc#>>'{metadata,month}',
       doc#>>'{metadata,day}' 
    ) as date
from 
	couchdb_users_meta 
where 
	doc#>>'{type}' = 'telemetry'  
order by 
	date desc

The query will return results that look like this:

user	date
----------------
bob	    2024-3-3
lisa	2024-3-3
tom	    2024-3-3
wonda	2024-3-3
marisa	2024-3-3

When using telemetry documents, be sure to remember that they may not happen everyday depending on CHW’s use of your app.

Please let us know if you need anymore help!