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