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



I am trying to use SugarQuery.


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

$sugarQuery = new SugarQuery();
$sugarQuery->join('accounts', array('alias' => 'acc'));
    ->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.