1

I am using Drupal Commerce Kickstart! I want to get 'Only' the country name from the shipping information of a particular order in a view, The shipping information field in my view shows the entire shipping address including the country at last, is there a way that I can extract only the country name from that? or a db query using the order_id?

Improve this question
1
  • any one who could answer this please?
    – Ashkar A.Rahman
    Commented Jan 27, 2014 at 5:58

3 Answers 3

Reset to default
2
+25

Implying that you have the Order ID in your view:

  1. Add a relationship to Commerce Order: Referenced customer profile, for the shipping address (Relate this entity to the customer profile referenced by its commerce_customer_shipping value)
  2. Add field for Commerce Customer profile: Address - Country

My output after those steps:

Order ID: 4
Bulgaria

Order ID: 5
United States

FYI the data is located in field_data_commerce_customer_address table commerce_customer_address_country column.

Improve this answer
3
  • Hello Victor, Thanks for the response. But this didn't work either, the country failed to display but the full address did. I wrote a db query to get the results out of it. Ill right it down.
    – Ashkar A.Rahman
    Commented Jan 28, 2014 at 6:53
  • Hey DropDragon, are you sure that you select the right data field? I'm positive that this Views set up imgur.com/yoSzvNG displays the output in my answer.
    – Victor Lazov
    Commented Jan 30, 2014 at 8:51
  • Yes I am sure I did it. but as posted before this doesn't show me the country name, but the replacement pattern works only for the full address Thank you.
    – Ashkar A.Rahman
    Commented Feb 7, 2014 at 12:35
0

Finally I did it by sending a DB query to get the address of a customer by an order id.

SELECT field_data_commerce_customer_address.commerce_customer_address_country as country
                FROM field_data_commerce_customer_address
                INNER JOIN field_data_commerce_customer_shipping
                ON field_data_commerce_customer_address.entity_id = field_data_commerce_customer_shipping.commerce_customer_shipping_profile_id
                WHERE field_data_commerce_customer_shipping.entity_id ='".$order_id."'"
Improve this answer
0

You can isolate the country field by enabling aggregation. Add address to your result set and group the results by the country field.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.