Hello,
I have CDbCriteria
$criteria = new CDbCriteria();
$criteria->join = "INNER JOIN datnkapst dnk ON dnk.nokapst=t.nokapst";
$criteria->together = true;
$criteria->select = array('t.nosjp','dnk.nmpst as nmpst','t.flagprsklaimsjp', 'convert(varchar(11), tglsjp, 106) as tglsjp'
,'t.mrpstsjp', 'convert(varchar(11), tglrjkawalsjp, 106) as tglrjkawalsjp', 't.nokapst', 't.norjkawalsjp'
,'t.ppkrjkawalsjp','t.diagppk','t.bytagsjp','t.byversjp','t.politujsjp','t.catkhssjp','t.refasalsjp','t.jnspelsjp','t.flagrrwt',
'convert(varchar(11), tglpulangsjp, 106) as tglpulangsjp');
//$criteria->with = array( "datnkapst" );
$criteria->limit = $limit;
$criteria->offset = $start;
but the field “dnk.nmpst” doesn’t show up in the json.
Already use alias, no luck.
[0] => Array
(
[nosjp] => xxxx
[flagprsklaimsjp] => xxx
[tglsjp] =>xxxx
[mrpstsjp] => xxxxx
[tglrjkawalsjp] => xxxx
[nokapst] => xxxxx
[norjkawalsjp] => xxxx
[ppkrjkawalsjp] => xxxx
[diagppk] => xxxx
[bytagsjp] => xxxxx
[byversjp] => xxxxx
[politujsjp] => xxxxx
[catkhssjp] => xxxx
[refasalsjp] => xxx
[jnspelsjp] => xxxx
[flagrrwt] => xxxxx
[tglpulangsjp] => xxxx
[nofpk] => xxxx
[pisapst] => xxx
[jnspstsjp] => xxx
[tgldtgsjp] => xxxx
[diagrs] => xxxx
[tglversjp] => xxx
[bystjsjp] => xxxx
[jmlkssjp] => xxxxx
[jmlstjsjp] => xxxx
[flagakhirsjp] => xxxx
[flagentrysjp] => xxxx
[idusersjp] => xxxx
[nipstjsjp] => xxxx
[ppkpelsjp] => xxxx
[flaglpstsjp] => xxxx
[flagpstrs] => xxxx
[tglstjkasie] => xxxx
[nipstjkasie] => xxxx
[tglstjrs] => xxxx
[namastjrs] => xxxx
[bytagobtsjp] => xxx
[byverobtsjp] => xxxx
[bystjobtsjp] => xxx
[nocetak] => xxxx
[nosjpsms] => xxxx
[diagppk2] => xxx
)
It is bugs or something??
help!!