Data entry statistics: Difference between revisions
From IHRIS Wiki
(→user) |
|||
Line 11: | Line 11: | ||
4 cleitner XXXXX Carl Leitner cleitner@intrahealth.org 2 | 4 cleitner XXXXX Carl Leitner cleitner@intrahealth.org 2 | ||
</pre> | </pre> | ||
===form=== | |||
This table is used to associate a numeric id to every form stored in the entry tables. Example is: | |||
<pre> | |||
id name type | |||
1 marital_status 0 | |||
2 person 0 | |||
</pre> | |||
==User Specific Queries== | ==User Specific Queries== | ||
===Lookup id by user name=== | ===Lookup id by user name=== |
Revision as of 08:56, 19 July 2012
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
form
This table is used to associate a numeric id to every form stored in the entry tables. Example is:
id name type 1 marital_status 0 2 person 0
User Specific Queries
Lookup id by user name
<source lang='sql'> SELECT id FROM `user` WHERE username='cleitner' </source> which will return '4'.