Assign custom attribute values to grid collection

[smita_kagwade]

Hello all,

I have a created a custom grid in admin ,

I want to assign custom attributes from customer to one of the column in the grid , I can get the value of attribute from customer repository but how can I pass it  to collection?

Any help appreciated.

Thank You.

[smita_kagwade · Accepted solution]

Hello all,

I have resolved this by joining my collection with table

`customer_entity_varchar` 

$customerEav = $collection->getTable('customer_entity_varchar');

     $collection->getSelect()->join(
            array('customereav'=>$customerEav),
            '`order`.customer_id = customereav.entity_id AND customereav.attribute_id=214',
            ['custom_attribute' => 'customereav.value']);

hope this helps you as well.

Thank You.

[rambhl]

Thanks a lot

Solved my problem