In my custom collection $career_collection->setOrder('career_id','ASC');
not working.
My function is below
public function getAllCareers(){
$Careers = $this->_careersFactory->create();
$career_collection = $Careers->getCollection();
$career_collection->addFieldToFilter('active',1)->setOrder('career_id','ASC');
//$career_collection->setOrder('career_id','ASC');
echo $career_collection->getSelect(); exit;
return $career_collection;
}
getSelect
return the query like below
SELECT `main_table`.* FROM `e25_careers` AS `main_table` WHERE (`active` = '1').
What is the wrong i am doing here