Data entry statistics

From IHRIS Wiki
Revision as of 08:44, 19 July 2012 by Litlfred (talk | contribs) (Created page with "All data entry and chagnes for forms with the "entry" form storage mechanism are tracked. However, there is no web interface to look at this data. Instead, we suggest that you ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

All data entry and chagnes for forms with the "entry" form storage mechanism are tracked. However, there is no web interface to look at this data. Instead, we suggest that you run specialized SQL queries in phpmyadmin.

We give some examples below

Tables

The following tables are relevant for making these queries:

user

This table contains a list of usernames and ids. The user's id is what is used to record data changes. Example is:

id 	username 	password 	firstname 	lastname 	email 	                        creator
4      cleitner 	XXXXX 	        Carl 	        Leitner 	cleitner@intrahealth.org 	2

User Specific Queries