09-04-2016, 08:52 PM
The easiest way to do that is using QueryGenerator:
Look at our unit tests for a lot of examples:
https://github.com/tsolucio/coreBOSTests/blob/master/include/QueryGenerator/QueryGeneratorTest.php
PHP Code:
$queryGenerator = new QueryGenerator('Accounts', $current_user);
$queryGenerator->setFields(array('id','cf_999'));
$queryGenerator->addCondition('id','22','e');
$query = $queryGenerator->getQuery();
$rs = $adb->query($query);
$cf_999 = $adb->query_result($rs,0,'cf_999');
Look at our unit tests for a lot of examples:
https://github.com/tsolucio/coreBOSTests/blob/master/include/QueryGenerator/QueryGeneratorTest.php
Joe
TSolucio
TSolucio