Insight filtering for objects by its attribute's changed date

Ferenc Kis_amkzsf

Hi,

We are using Insight as our CRM system. We have 3000+ object and all of them has got 50+ attributes.

There was a request to list all objects that defined attribute was changed in an interval.

Through an example:
Customer is the object, and it has got an attribute "Status" (with the values of Prospect, Live, Cancelled)

I would like to get a list of those objects where the "Status" attribute was changed in the last 30 days. Even better if it could be filtered for a specific status ie Live

I know that there is an Updated attribute as default but that is changing everytime if anything was changed and I need to check for a particular attribute's change

Cristian Iorio

I came here because I was looking for possible solutions. I think it is not possible to filter the 'Status' attribute based on the time spent with that particular value.
This feature is there for JQLs but, objectively, the status of an issue is different from the 'Status' attribute of an object.

I was asked if it was possible to use the 'status CHANGED DURING LAST' function. I believe the answer is no and I cannot find any other evidence in the community. 

Also, in the official Atlassian documentation about AQLs there are no such functions listed: https://support.atlassian.com/jira-service-management-cloud/docs/use-assets-query-language-aql/