Clarity

  • 1.  Query for Projects

    Posted 05-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 05-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:

     

    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



  • 3.  Re: Query for Projects
    Best Answer

    Posted 05-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.