• Sugar Query - Ifnull

    Hi everyone. I am attempting to convert all of my Raw SQL into Sugar Query, having mostly success following the guide @ https://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_9.2/Data_Framework/Database/SugarQuery/ However…

  • How to filter through records using bean factory

    Hello Sugar Developer Community I am having difficulties accomplishing the following -- Entrypoint :: create leads JSON is sent over and the creation of the lead is underway I am passed a value that would represent a company name to place into a company…

  • 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'));…