Clarity

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:

select

    inv.code Investment_ID

    , aud.*

from

    inv_investments inv

    , cmn_audits aud

where

    inv.id = aud.object_id

    and aud.column_name = 'IS_ACTIVE'

Dale

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_AUDITS
where 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.