Retrieving the date of creation for annotations in IBM FileNet Image Services?

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:

(0 users)Average rating

Add comments

Document information


More support for:

FileNet Image Services
Image Services

Software version:

4.1.1, 4.1.2, 4.2

Operating system(s):

AIX, HP Itanium, HP-UX, Solaris, Windows

Software edition:

All Editions

Reference #:

1618724

Modified date:

2013-09-13

Translate my page

Machine Translation

Content navigation