Clarity

  • Private Community

  • 1.  Global Audit Trail Portlet

    Posted Feb 04, 2014 06:25 AM

    Hi All,

    We are trying to build a customized portlet similar to out-of-the box Global Audit Trail portlet. But when I am joining cmn_audits and inv_investments table getting more rows. Even, I tried to do the SQL Trace to get the query of this portlet but no use.

    Please anybody suggest me how can i get the same portlet as the out of the box one. 

    Thanks & Regards

    Madhuri Thakur

     



  • 2.  RE: Global Audit Trail Portlet

    Posted Feb 04, 2014 07:34 AM

    Hi Madhuri,

    I would recommend you to visit the link here that should enable you to get hold of the query for any portlet. Hope this helps!

    Suhail.



  • 3.  RE: Global Audit Trail Portlet

    Posted Feb 04, 2014 07:42 AM

    Hi Madhuri,

    While joining cmn_audits and inv_investments, are you specifying the CMN_AUDITS.OBJECT_CODE? I assume you are missing that part in your join.

    Thanks,

    Georgy



  • 4.  RE: Global Audit Trail Portlet

    Posted Feb 04, 2014 07:47 AM

    Hi All,

    Thanks for the quick response.

    No Georgy, I am using OBJECT_CODE in my query, still I am getting the same.

    Thanks

    Madhuri Thakur



  • 5.  RE: Global Audit Trail Portlet

    Posted Feb 04, 2014 08:14 AM

    Perhaps you need to post your SQL/NSQL, we can not see what would be wrong with it without seeing it!
     



  • 6.  RE: [Clarity Business Objects] RE: Global Audit Trail Portlet
    Best Answer

    Posted Feb 04, 2014 08:25 AM
    Here’s what I just tried and it worked just fine:

    select * from cmn_audits a inner join inv_investments i on a.object_code = i.odf_object_code and a.object_id = i.id