cancel
Showing results for 
Search instead for 
Did you mean: 

Getting History of modified attributes and its value updated through impex

Former Member

Hi ,

Attributes of products are updated in our system through impex. Just for record purpose we want to retrieve attributes,which are modified and its old value.How can we get list of modified attribute.In hmc we are only able to get attributes modified through hmc not from impex.

Regards,

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

OOB hybris provides the functionality of SavedValues(old attribute's values). Every item can contain a collection of SavedValues. A single SavedValue consists of timestamp data and a collection of SavedValueEntries. Each SavedValueEntry stores a single individual attribute value modification.

You must call the logging functionality explicitly in your application code.

Please go through the below link for more details:

https://wiki.hybris.com/display/release5/SavedValues+-+Keeping+Track+of+Attribute+Value+Modification...

Former Member
0 Kudos

We wanted to recover some data loss for few of attributes which are updated by mistake. So there is no way to get older value of attributes, updated through impex. It could be an ongoing change in existing system.

Former Member
0 Kudos

Hi,

In flexibleSearch editor in hAC, execute the following query:

                         select * from {product} where {modifiedtime} >= '2015-11-17 00:00:00.000'

Provide the date parameter as of your requirement.

Former Member
0 Kudos

Hi Sourav,

Using above flexible search query,i can get list of modified products after specific date. But This is not my requirement. Consider There is product with code 123 and having attribute description value as ABC. Now we have updated the description for above product code from ABC to DEF using impex. Is there a way to get old value of description attribute for product code 123 ? If we update the attribute value through hmc,we get it easily.

Regards,