Gsyfuy

Why zero tolerance on nudity in space?

Current across a wire with zero potential difference

How do you voice extended chords?

What makes papers publishable in top-tier journals?

Can I announce prefix 161.117.25.0/24 even though I don't have all of /24 IPs

A starship is travelling at 0.9c and collides with a small rock. Will it leave a clean hole through, or will more happen?

Separate environment for personal and development use under macOS

What is the difference between rolling more dice versus fewer dice?

I have trouble understanding this fallacy: "If A, then B. Therefore if not-B, then not-A."

How would an AI self awareness kill switch work?

Explanation of a regular pattern only occuring for prime numbers

TikZ graph edges not drawn nicely

Macro expansion inside href

Play Zip, Zap, Zop

How to make ice magic work from a scientific point of view?

What is a good reason for every spaceship to carry a weapon on board?

False written accusations not made public - is there law to cover this?

How to not let the Identify spell spoil everything?

How much mayhem could I cause as a fish?

Looking for a specific 6502 Assembler

What is a DAG (Graph Theory)?

After checking in online, how do I know whether I need to go show my passport at airport check-in?

Why avoid shared user accounts?

Why was Lupin comfortable with saying Voldemort's name?

How to add custom columns into a custom collection class?

Add Customer name to my custom collectionMerge custom collection into customer/address collectionCollection addAttributeToSelect multiple columns in queryMagento - Add custom table data into Products collectionhow to add pagination on custom collection in Magento 2Magento 2.1 Create a filter in the product grid by new attributeMagento 2 Add new field to Magento_User admin formCollection Multiple Columns as ORI am trying to join wishlist and wishlist_item to be displayed in an admin gridMagento2 add custom values in collection->setOrder

0

I've a custom collection class for my custom backend grid, there is the initSelect method, i want to add a custom column but not successful, the actual thing i want to do in sql is "999 as USER_VALUE"

SELECT PRODUCT_ID, ORDER_QUANTITY, 999 as USER_VALUE

FROM PRODUCT_TABLE

I've tried

$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);

but it marks dummy as maintable.dummy, so it results in error, the following is the initSelect()

protected function _initSelect()

{

    parent::_initSelect();



    /*$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);*/



    $this->getSelect()->joinLeft(

        ['secondTable' => $this->getTable('sales_order_address')],

        'main_table.shipping_address_id = secondTable.entity_id', 

        ['name' => "CONCAT(firstname, ' ', lastname)", 'company', 'telephone', 'city']



    );





}

Anyone know how to do that?

magento2 collection

share

asked 4 mins ago

hkguilehkguile

98032754

add a comment | 

0

I've a custom collection class for my custom backend grid, there is the initSelect method, i want to add a custom column but not successful, the actual thing i want to do in sql is "999 as USER_VALUE"

SELECT PRODUCT_ID, ORDER_QUANTITY, 999 as USER_VALUE

FROM PRODUCT_TABLE

I've tried

$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);

but it marks dummy as maintable.dummy, so it results in error, the following is the initSelect()

protected function _initSelect()

{

    parent::_initSelect();



    /*$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);*/



    $this->getSelect()->joinLeft(

        ['secondTable' => $this->getTable('sales_order_address')],

        'main_table.shipping_address_id = secondTable.entity_id', 

        ['name' => "CONCAT(firstname, ' ', lastname)", 'company', 'telephone', 'city']



    );





}

Anyone know how to do that?

magento2 collection

share

asked 4 mins ago

hkguilehkguile

98032754

add a comment | 

I've a custom collection class for my custom backend grid, there is the initSelect method, i want to add a custom column but not successful, the actual thing i want to do in sql is "999 as USER_VALUE"

SELECT PRODUCT_ID, ORDER_QUANTITY, 999 as USER_VALUE

FROM PRODUCT_TABLE

I've tried

$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);

but it marks dummy as maintable.dummy, so it results in error, the following is the initSelect()

protected function _initSelect()

{

    parent::_initSelect();



    /*$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);*/



    $this->getSelect()->joinLeft(

        ['secondTable' => $this->getTable('sales_order_address')],

        'main_table.shipping_address_id = secondTable.entity_id', 

        ['name' => "CONCAT(firstname, ' ', lastname)", 'company', 'telephone', 'city']



    );





}

Anyone know how to do that?

magento2 collection

share

asked 4 mins ago

hkguilehkguile

98032754

SELECT PRODUCT_ID, ORDER_QUANTITY, 999 as USER_VALUE

FROM PRODUCT_TABLE

$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);

protected function _initSelect()

{

    parent::_initSelect();



    /*$this->getSelect()

        ->reset(Zend_Db_Select::COLUMNS)

        ->columns(['dummy' => '999']);*/



    $this->getSelect()->joinLeft(

        ['secondTable' => $this->getTable('sales_order_address')],

        'main_table.shipping_address_id = secondTable.entity_id', 

        ['name' => "CONCAT(firstname, ' ', lastname)", 'company', 'telephone', 'city']



    );





}

share

asked 4 mins ago

hkguilehkguile

98032754

share

asked 4 mins ago

hkguilehkguile

98032754

asked 4 mins ago

hkguilehkguile

98032754

asked 4 mins ago

hkguilehkguile

98032754