Topic
  • 2 replies
  • Latest Post - ‏2012-11-21T01:02:33Z by KaranBal
SystemAdmin
SystemAdmin
648 Posts

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

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

    ‏2012-11-20T09:43:06Z  
    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

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

    ‏2012-11-21T01:02:33Z  
    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 ...;