The following examples illustrate how to query the MAP_EVENT and MAP_EVENT audit table. To successfully query for records of interest, you might have to perform several queries or use additional, more complex constraints. For example, if you are searching for all records for a user named Jane Doe, with the username jdoe, you may have to search for records for both Jane Doe and jdoe.
To minimize the impact of queries on system resources, constrain all queries as much as possible. If your queries still return a large set of results, contact your service representative to assist you.
 | Note: The DATE_TIME_CREATED field contains the date as a UNIX timestamp. |
The following examples analyze records for the month of January 2005 (12:00:00 midnight, January 1 to 11:59:59 PM January 31).
| To | Type |
|---|---|
Analyze records for a particular patient |
select * from MAP_EVENT where PATIENT_ID='1234' and DATE_TIME_CREATED between 1104537600 and 1107172799 |
Analyze records for a particular study |
select * from MAP_EVENT_AUDIT where STUDY_UID='1.23.4.567.8.9.1011.1213.14' and DATE_TIME_CREATED between 1104537600 and 1107172799 |
Analyze records for a particular station |
select * from MAP_EVENT where machine_ID='1.2.3.4' and DATE_TIME_CREATED between 1104537600 and 1107172799 |
Analyze records for a particular IMPAX user (1) |
select * from MAP_EVENT_AUDIT where USER_ID='Jane Doe' and DATE_TIME_CREATED between 1104537600 and 1107172799 |
Analyze records for a particular IMPAX user (2) |
select * from MAP_EVENT_AUDIT where USER_ID='jdoe' and DATE_TIME_CREATED between 1104537600 and 1107172799 |
Analyze records for a particular IMPAX user and order them by the date the event occurred |
select * from MAP_EVENT where USER_ID in ('jdoe', 'Jane Doe') and DATE_TIME_CREATED between 1104537600 and 1107172799 order by DATE_TIME_CREATED |
 | Tip: To query both the MAP_EVENT and MAP_EVENT_AUDIT tables, use the UNION ALL SQL command. If you are not familiar with these SQL commands, contact your support representative. |