AUDIT_LOG table contains only the entity type say BUG.But it does not have the field for which the change was made say BG_STATUS.It is available from the AUDIT_PROPERTIES
I want to query database in this manner: select all the records for which the bug status was changed on a particular day say 10/30/2008.
I approached this query by polling every bug's history to check if the changed date of the bug status was 10/30/2008.This solution was taking too much of time.
So I thought of directly querying the AUDIT_RECORD,but it does not have the field information.
How can I use both the tables:AUDIT_RECORD and AUDIT_PROPERTIES to get the desired results.