source/Application/Model/Category.php
public function getFieldFromSubCategories($sField = 'OXID', $sOXID = null)
    {
        if (!$sOXID) {
            $sOXID = $this->getId();
        }
        if (!$sOXID) {
            return false;
        }

        $sTable = $this->getViewName();
        $sField = "`{$sTable}`.`{$sField}`";
        $sSql = "SELECT $sField FROM `{$sTable}` WHERE `OXROOTID` = ? AND `OXPARENTID` != 'oxrootid'";
        $aResult = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->getCol($sSql, [$sOXID]);

        return $aResult;
    }
public function getFieldFromSubCategories($sField = 'OXID', $sOXID = null)
    {
        if (!$sOXID) {
            $sOXID = $this->getId();
        }
        if (!$sOXID) {
            return false;
        }

        $sTable = $this->getViewName();
        $sField = "`{$sTable}`.`{$sField}`";
        $sSql = "SELECT $sField FROM `{$sTable}` WHERE `OXROOTID` = ? AND `OXPARENTID` != 'oxrootid'";
        $aResult = \OxidEsales\Eshop\Core\DatabaseProvider::getDb()->getCol($sSql, [$sOXID]);

        return $aResult;
    }
public function getFieldFromSubCategories ( $ sField = 'OXID' , $ sOXID = null ) { if ( ! $ sOXID ) { $ sOXID = $ this -> getId ( ) ; } if ( ! $ sOXID ) { return false ; } $ sTable = $ this -> getViewName ( ) ; $ sField = "`{$sTable}`.`{$sField}`" ; $ sSql = "SELECT $sField FROM `{$sTable}` WHERE `OXROOTID` = ? AND `OXPARENTID` != 'oxrootid'" ; $ aResult = \ OxidEsales \ Eshop \ Core \ DatabaseProvider :: getDb ( ) -> getCol ( $ sSql , [ $ sOXID ] ) ; return $ aResult ; }
Gets one field from all of subcategories.
Default is set to 'OXID'

@param string $sField field to be retrieved from each subcategory
@param string $sOXID  Cetegory ID

@return array
Gets one field from all of subcategories . Default is set to OXID