List Document Cache Properties statement

Lists all of the properties for a document cache.

LIST [ALL] PROPERTIES FOR DOCUMENT 
 CACHE (NAME "cache_name" 
 | GUID cache_guid) IN PROJECT 
 "project_name";

where:

• NAME "cache_name" is the name of the cache for which its properties are to be listed, of type string.

• cache_guid is the GUID of the cache, of type GUID.

• PROJECT "project_name" is the project containing the cache, of type string.

This statement can only be used with three-tier or four-tier project source names.

Example

LIST ALL PROPERTIES 
 FOR DOCUMENT CACHE "Summary Dashboard" IN PROJECT "Tech 
 Demo";

ResultSet Columns

CACHE_FILE_NAME: The name of the cache file, returned as a string.

CACHE_FILE_SIZE: The file size of the cache, returned as an integer.

CACHE_FORMAT: The format of the cache, returned as an integer:

• 1: Excel
• 2: PDF
• 3: CSV
• 4: HTML
• 5: Plain text
• 6: XML
• 7: Flash
• 8: View
• 9: Interactive
• 10: Editable
• 11: Flash export
• 12: Flash in MHT
• 13: Flash in PDF
• 14: Mobile smartphone
• 15: Mobile tablet

CACHE_GROUP_BY: Any page-by used in the cache, returned as a string.

CACHE_MD_LANGUAGE: The metadata language used to generate the cache, returned as a string.

CREATION_TIME: Date and time the cache was created, returned as a date/string.

CREATOR: User who created the cache, returned as a string.

DOCUMENT_ID: GUID of the document that is cached, returned as a string.

EXPIRATION: Date and time the cache expires, returned as a date/string.

HIT_COUNT: The current hit count of the cache, returned as an integer.

ID: ID of the cache, returned as a string.

LANGUAGE: The language of the document that is cached, returned as a string.

LAST_HIT_TIME: Date the cache was last hit, returned as a date/string.

LAST_LOAD_TIME: Date the cache was last loaded, returned as a date/string.

LAST_UPDATED_TIME: Date the cache was last updated, returned as a date/string.

METADATA_LANGUAGE: The language of the metadata used to generate the document cache, returned as a string.

PROJECT: The name of the project, returned as a string.

REPORT_CACHE: The report cache used by the document cache, returned as a string.

STATUS_LIST: A ResultSet listing the statuses of the cache.