Could anyone please provide the query to get export date or/and communication date per item and catalog?
Thanks in Advance !
This topic has been locked.
2 replies Latest Post - 2012-11-21T01:02:33Z by KaranBal
Pinned topic export date or/and communication date per product and country
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-21T01:02:33Z at 2012-11-21T01:02:33Z by KaranBal
SystemAdmin 110000D4XK648 PostsACCEPTED ANSWER
Re: export date or/and communication date per product and country2012-11-20T09:43:06Z in response to SystemAdminHi 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 270004GTF1108 PostsACCEPTED ANSWER
Re: export date or/and communication date per product and country2012-11-21T01:02:33Z in response to SystemAdminAs 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 ...;