How would one create a query to see inactive projects and when they were made inactive? For example, if I look in the audit log I can see when i made an investment inactive. Is there a query that can do this so I don't have to manually look in every project to pull this data?
Any help is appreciated, I am not a SQL expert.
No query available out of the box that I’m aware of. You’ll have to build your own – something like:
, cmn_audits aud
inv.id = aud.object_id
and aud.column_name = 'IS_ACTIVE'
If you are having the audits activated for Project object on that "Active" field then you can query the database to get the dates for all the projects.
select * from CMN_AUDITSwhere OBJECT_CODE = 'project'and attribute_code = 'is_active';
and you can add the following condition for a specific project:
--and OBJECT_ID = <<internal 5 million id of the project>>
But if the audit of the Active attribute is not enabled, then there is no other way.
Hope that helps.