Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
2 replies Latest Post - ‏2012-11-21T01:02:33Z by KaranBal
SystemAdmin
SystemAdmin
648 Posts
ACCEPTED ANSWER

Pinned topic export date or/and communication date per product and country

‏2012-11-20T09:26:39Z |
Hi

Could anyone please provide the query to get export date or/and communication date per item and catalog?

Thanks in Advance !

Regards,
Sandip
Updated on 2012-11-21T01:02:33Z at 2012-11-21T01:02:33Z by KaranBal
  • SystemAdmin
    SystemAdmin
    648 Posts
    ACCEPTED ANSWER

    Re: export date or/and communication date per product and country

    ‏2012-11-20T09:43:06Z  in response to SystemAdmin
    Hi Sandip,

    What do you mean under "export date or/and communication date per item and catalog"? There are no build-in attributes/parameters regarding update/create/export and other dates of items and catalogs.
    There is notion "Version of catalog". You can get a date of one via API. Versions are created during import/export jobs and manually.
  • KaranBal
    KaranBal
    108 Posts
    ACCEPTED ANSWER

    Re: export date or/and communication date per product and country

    ‏2012-11-21T01:02:33Z  in response to SystemAdmin
    As Alexander suggested, use the versions to find out when a catalog was updated via an import or export. If you have not deleted the older versions, then you can get this information in following ways:
    1. Go to the catalog console, select the catalog and click attributes. At the bottom of the resultant page, you will see the different versions which have been created via imports and when.
    2. Use the following SQL(go to "System Administrator" > "DB Admin") to find the same information:
    select * from ver where ver_company_id in (select CMP_COMPANY_ID from cmp where CMP_COMPANY_CODE='Code_of_Company') and VER_OBJECT_ID in(select CTG_ID from ctg where CTG_NAME='Name of catalog');
    3. Run the following SQL(note the output needs to be converted and is not in human readable form):
    select ITM_LAST_MODIFIED from itm where ...;