Data entry statistics: Difference between revisions
From IHRIS Wiki
(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 ...") |
|||
| Line 12: | Line 12: | ||
</pre> | </pre> | ||
==User Specific Queries== | ==User Specific Queries== | ||
===Lookup id by user name=== | |||
<source lang='sql'> | |||
SELECT id FROM `user` WHERE username='cleitner' | |||
</source> | |||
which will return '4'. | |||
Revision as of 08:50, 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
User Specific Queries
Lookup id by user name
<source lang='sql'> SELECT id FROM `user` WHERE username='cleitner' </source> which will return '4'.
