Technote (FAQ)
Question
How to retrieve the date of creation for annotations in IBM FileNet Image Services?
Cause
Need to identify date of creation for annotations in IBM FileNet Image Services
Answer
The annotations table in Permanent database maintains a record for each annotation and its associated document and page. The actual annotation text is stored in a hexadecimal format.
<MKF_tool>desc annotations
annotations: record
(
annot_key: group
(
doc_id: unsigned long;
page: unsigned short;
ssn: unsigned long;
annot_id: unsigned long;
) unique key;
create_date: datetime;
modify_date: datetime;
security_len: unsigned byte;
security_info: hex byte [security_len : 12];
capability: hex byte [20];
data_len: unsigned short;
data: hex byte [data_len : 800];
);
Can query the Permanent database using the date created for all documents:
<MKF_tool>select annotations * showing doc_id annot_id create_date
doc_id annot_id create_date
------ -------- -----------
...
746029 1 1347316353 => 09/10/2012 15:32:33
746029 2 1347316353 => 09/10/2012 15:32:33
746029 3 1353368307 => 11/19/2012 15:38:27
...
Can query the Permanent database for a single document:
<MKF_tool>select annotations * where doc_id= 727220 showing doc_id annot_id create_date
doc_id annot_id create_date
------ -------- -----------
727220 1 1343256591 => 07/25/2012 15:49:51
727220 2 1343256621 => 07/25/2012 15:50:21
727220 3 1343256646 => 07/25/2012 15:50:46
727220 4 1343256671 => 07/25/2012 15:51:11
Can also query the Permanent database using both date created and modified:
<MKF_tool>select annotations * showing doc_id annot_id create_date modify_date
...
doc_id.............746029 annot_id................1
create_date....1347316353 => 09/10/2012 15:32:33
modify_date....1347316353 => 09/10/2012 15:32:33
--------------------------------------------------------------------doc_id.............746029 annot_id................2
create_date....1347316353 => 09/10/2012 15:32:33
modify_date....1347316353 => 09/10/2012 15:32:33
--------------------------------------------------------------------doc_id.............746029 annot_id................3
create_date....1353368307 => 11/19/2012 15:38:27
modify_date....1353368307 => 11/19/2012 15:38:27
....
<MKF_tool>quit
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.