AnsweredAssumed Answered

[sugarquery] invisible columns of joined table

Question asked by Bruce Park on Sep 6, 2017
Latest reply on Sep 7, 2017 by Mehul Bhandari

Hi,

 

I am trying to use SugarQuery.

 

These are very simple procedures which join statement is being used.

$sugarQuery = new SugarQuery();
$sugarQuery->from(BeanFactory::newBean('Opportunities'));
$sugarQuery->join('accounts', array('alias' => 'acc'));
$sugarQuery->where()
    ->lte('lastpriceincreasedate_c', $selected_date);
$opp_rows = $sugarQuery->execute();

There is no error after running it but I cannot see the columns from accounts and I can see only the column from Opportunities.

I chose columns using select function but the columns only being shown are all from Opportunities.

 

How can I see the all columns?

 

Thank you.

Outcomes