• SugarQuery - Aggregates not working..

    Hi Folks Running a query in MySQL. it's working but the same I'm trying with SugarQuery not getting any result. Query.. MySQL Query - SELECT enjay_tally_group_c, count(0) AS record_count FROM tl_tally_ledger_cstm GROUP BY enjay_tally_group_c And same…
  • How do I use not equal in SugarQuery (version 7.6)?

    Hi, I do following http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.6/API/Classes/SugarQuery/ My code below: $beanCall = BeanFactory::newBean('Calls'); $sugarQuery = new SugarQuery(); $sugarQuery->select(array('id'));…