View Only
  • 1.  Query for Projects

    Posted May 17, 2019 02:35 PM

    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.

  • 2.  Re: Query for Projects

    Posted May 17, 2019 02:49 PM

    No query available out of the box that I’m aware of.  You’ll have to build your own – something like:



        inv.code Investment_ID

        , aud.*



        inv_investments inv

        , cmn_audits aud


    where = aud.object_id

        and aud.column_name = 'IS_ACTIVE'



  • 3.  Re: Query for Projects
    Best Answer

    Posted May 20, 2019 07:15 AM

    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.