Sunday, 11 November 2018

Magento2 orders get with customer name and phone number eav attribute

SELECT increment_id,customer_id  FROM `sales_order` WHERE `created_at` >= '2018-10-01 00:00:00'

SELECT so.increment_id,so.customer_id,cev.value as customer_mobile_number FROM `sales_order` so LEFT JOIN customer_entity_varchar as cev ON so.customer_id=cev.entity_id AND cev.attribute_id=1184 WHERE `created_at` >= '2018-10-01 00:00:00'


SELECT so.increment_id,CONCAT(so.customer_firstname, ' ', so.customer_lastname) AS "Customer",cev.value as customer_mobile_number FROM `sales_order` so LEFT JOIN customer_entity_varchar as cev ON so.customer_id=cev.entity_id AND cev.attribute_id=1184 WHERE `created_at` >= '2018-10-01 00:00:00'

SELECT so.increment_id,CONCAT(ce.firstname, ' ', ce.lastname) AS "Customer",cev.value as customer_mobile_number FROM `sales_order` so LEFT JOIN customer_entity_varchar as cev ON so.customer_id=cev.entity_id AND cev.attribute_id=1184 LEFT JOIN customer_entity as ce ON ce.entity_id=so.entity_id WHERE `created_at` >= '2018-10-01 00:00:00'   

SELECT so.increment_id,CONCAT(ce.firstname, ' ', ce.lastname) AS "Customer",cev.value as Mobile FROM `sales_order` so LEFT JOIN customer_entity_varchar as cev ON so.customer_id=cev.entity_id AND cev.attribute_id=1184 LEFT JOIN customer_entity as ce ON ce.entity_id=so.customer_id WHERE so.`created_at` >= '2018-10-01 00:00:00'

No comments:

Post a Comment