Thread Details
  • State Verified Answer
  • Replies 2 replies
  • Subscribers 373 subscribers
  • Views 1612 views
  • Users 0 members are here
Forum Actions
Related

How do I use not equal in SugarQuery (version 7.6)?

Autchara Chaiprom

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'));
$sugarQuery->from($beanCall, array('team_security' => false));
$sugarQuery->where()
     ->queryAnd()
     ->equals('parent_id',$bean->parent_id)
     ->equals('parent_type','Cases');           
$arrCall = $sugarQuery->execute();

I would like to use not equal  in SugarQuery but no example in tutorial.

How do I user != in SugarQuery in Sugarcrm 7.6 ?

It available in Sugarcrm 7.7 

http://support.sugarcrm.com/Documentation/Sugar_Developer/Sugar_Developer_Guide_7.7/Data_Framework/Database/SugarQuery/S…

Sugar 7.6 Ent

Thanks,

M

Parents
  • 0

    Hi Autchara,

    Try "notEquals" in your query,It is something like below

    $beanCall = BeanFactory::newBean('Calls');  
$sugarQuery = new SugarQuery();  
$sugarQuery->select(array('id'));  
$sugarQuery->from($beanCall, array('team_security' => false));  
$sugarQuery->where()  
            ->queryAnd()  
            ->notEquals('parent_id',$bean->parent_id)  
            ->notEquals('parent_type','Cases');             
$arrCall = $sugarQuery->execute();

    Hope this helps!.

Reply
  • 0

    Hi Autchara,

    Try "notEquals" in your query,It is something like below

    $beanCall = BeanFactory::newBean('Calls');  
$sugarQuery = new SugarQuery();  
$sugarQuery->select(array('id'));  
$sugarQuery->from($beanCall, array('team_security' => false));  
$sugarQuery->where()  
            ->queryAnd()  
            ->notEquals('parent_id',$bean->parent_id)  
            ->notEquals('parent_type','Cases');             
$arrCall = $sugarQuery->execute();

    Hope this helps!.

Children