AnsweredAssumed Answered

How to perform custom groupby and orderby in a custom dashlet for sugar 6.5?

Question asked by Rodolfo Tuble on Jul 13, 2016
Latest reply on Jul 13, 2016 by Rodolfo Tuble

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' => ' date_entered'

  );

 

But the groupby isn't working. I also tried custom_groupBy but still not working.

Outcomes