cancel
Showing results for 
Search instead for 
Did you mean: 

Retrieving the date an attribute was set to a specific value

Solved
Highlighted
Frequent Contributor

Retrieving the date an attribute was set to a specific value

Hi,

 

I'm trying to run a query that will provide a list of applications where the status was set to the "Retired" value within the past 10 days. Does anyone have any ideas on the most efficient way to retrieve the date a MetaAttribute was set to a specific MetaAttributeValue? 

 

Thanks,

Philippe

3 Replies
MEGA Partner

Re: Retrieving the date an attribute was set to a specific value

In my case i would use something like if you has logs enabled:

 

Select [ChangeItemDataPublic] Into @cidp Where [Creation Date]> "12/17/2018 2:00 pm" And [MetaAttribute] = "Application Template"
Select [Application] Into @apps Where [Application Template] = "Yes"
Select [Application] From @apps Where [ChangeItemDataPublic Log] in @cidp

 

Frequent Contributor

Re: Retrieving the date an attribute was set to a specific value

Hi,

 

thanks for the reply. I have been trying to do this, but performance is pretty slow, since the script has to run through all the log items - in some cases we have applications that have 2-3 years of changes logged. I was curious if there was maybe a quicker way to do this.

 

Thank you!

MEGA Partner

Re: Retrieving the date an attribute was set to a specific value

I believe there is a update available from mega which increases the performance of logs retrieval. Other then the current solution to audit I am not aware of any other solution.