Collection does not return the intended results

Question

I am working with the collection from a module trying to return specific information. The database has several columns but I only want 2: "region_id" & "default_name". But, every time I run this function, returns nothing and when I do $CollectionOrigin->getSelect->__toString() I get the correct resulting SQL command, which returns the correct values when run in the Database. here's my function, can someone tell me what I'm missing

Answer 1

1] Fetching collection with single table use the below code.

$collection = $this->reservationFactory->create()->getCollection();
$collection->addFieldToFilter('quote_id',$quote_id);

2] Fetching product layer collection with EAV tables use the below code.

$collection = $layer->getProductCollection();
$collection->addAttributeToFilter('status',1);

3] I assume you have a single table then can you modify the code as below.

$id = 1234;
$regionCollectionOrigin = $this->_regionFactory->create()->getCollection();
$regionCollectionOrigin->addFieldToFilter('region_id',$id);
var_dump($regionCollectionOrigin->getData();)exit; 

Answer 2

Use this code to get the default name and region id

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
$region = $objectManager->create('Magento\Directory\Model\Region')
                        ->loadByCode('CA', 'US');
echo "<pre>";
print_r($region->getData());

Output:

Array
(
    [region_id] => 12
    [country_id] => US
    [code] => CA
    [default_name] => California
    [name] => California
)

Answer 3

Get the default name using region id

<?php
 
use Magento\Directory\Model\RegionFactory;
 
class Save extends \Magento\Framework\App\Action\Action 
{
 protected $regionFactory;
 
 public function __construct(
 RegionFactory $regionFactory
 ){
 $this->regionFactory = $regionFactory;
  }
        $regionId = '1';
        public function getRegionData( $regionId ){
         $region = $this->regionFactory->create()->load($regionId);
         echo "<pre>";
         print_r($region->getData());
       }
}

OUTPUT

Array
(
    [region_id] => 1
    [country_id] => US
    [code] => AL
    [default_name] => Alabama
    [name] => Alabama
)