Skip to main content

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

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.

Rate this page:


(0 users)Average rating

Add comments

Document information

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-01-03

Translate my page

Content navigation