• How to add related module custom field to a dashlet column and filter

    Hello! We have a custom module Transactions which has relation to Accounts module custom field funded_c . How to show that field in the Transactions dashlet with possibility to filter? Searched a lot, but no similar cases found. Help!
  • How to perform custom groupby and orderby in a custom dashlet for sugar 6.5?

    I am trying to perform a custom query inside my custom dashlet. This is my query at the moment: $lvsParams = array( 'custom_select' => ' ,MIN(due_date) as min_date', // 'custom_from'=> '', 'custom_where' => ' AND due_date >= "'.$dbformat.'"', 'custom_groupby…