//cambiar esto por PROPEL //CASE_CONSOLIDATED TASK $usrUid = $_SESSION["USER_LOGGED"]; $oCriteria = new Criteria("workflow"); $oCriteria->addSelectColumn("*"); $oCriteria->addSelectColumn(CaseConsolidatedPeer::TAS_UID); $oCriteria->addJoin(CaseConsolidatedPeer::TAS_UID,ContentPeer::CON_ID, Criteria::LEFT_JOIN); $oCriteria->addJoin(CaseConsolidatedPeer::TAS_UID,TaskPeer::TAS_UID, Criteria::LEFT_JOIN); $oCriteria->addAnd(ContentPeer::CON_CATEGORY, "TAS_TITLE"); $oCriteria->addAnd(ContentPeer::CON_LANG, "en"); $params = array(); //This will be filled with the parameters $sql = BasePeer::createSelectSql($oCriteria, $params); $oDataset = CaseConsolidatedPeer::doSelectRS($oCriteria); $oDataset->setFetchmode(ResultSet::FETCHMODE_ASSOC); //$oDataset->next(); while ($oDataset->next()) { $aRow = $oDataset->getRow(); //$aTaskConsolidated [] = $aRow; } $query = "SELECT * FROM CASE_CONSOLIDATED LEFT JOIN CONTENT ON (CASE_CONSOLIDATED.TAS_UID = CONTENT.CON_ID) LEFT JOIN TASK ON (CASE_CONSOLIDATED.TAS_UID = TASK.TAS_UID) WHERE CONTENT.CON_CATEGORY='TAS_TITLE' AND CONTENT.CON_LANG='en'"; $aTaskConsolidated = executeQuery($query); $conf = new Configurations();