Magento 2 How to get only one field data in collection

Question

I want to get only one field data in my custom module collection. For ex:

getting following data in collection:

Array
   (
[0] => Array
    (
        [banner_id] => 1
        [banner_title] => Banner 1
        [banner_image] => banner_banner/4/_/4.jpg
        [banner_status] => 0
        [banner_link] => http://google.com
        [banner_sortorder] => 1
    )

)

getting this array in collection response. I need only one value in collection response banner_image. I don't want all the data in collection response. How can i do that?

Is there any method that allows me to fetch only that specific field data instead of loading entire collection?

I want following result only:

   Array
   (
   [0] => Array
    (

        [banner_image] => banner_banner/4/_/4.jpg

    ),
   [2] => Array
    (

        [banner_image] => banner_banner/2/_/892.jpg

    )

)

Answer 1

Can you just try this?

$collection = $customObject->getCollection()->addFieldToSelect('banner_image');

addFieldToSelect('column_name') will work here I think.

Answer 2

Magento has an inbuilt function on Magento\Framework\Data\Collection which provide a specific field value from the collection.

You have to use getColumnValues($colName) for getting the specific field value

$collectionObject->addFieldToSelect('banner_image')->getColumnValues('banner_image')

Answer 3

Here is your solution :-

$objectManager = \Magento\Framework\App\ObjectManager::getInstance();
    $categoryCollection = $objectManager->create('\Magento\Catalog\Model\Category');
    $collection = $categoryCollection->getCollection()->addFieldToFilter('name','MyCards');
    if($collection->count()) {
        return $collection->getFirstItem();
    }else{
      return false;
    }