SELECT `auftragsnummer`,`phone_2`,`phone_1`,`company`,`address_1`,`address_2`,`zip`,`city`,`virtuemart_country_id`,`managersqlid`,`first_name`,`last_name`,`middle_name`,`title`,`fax` FROM `nawssrt4_virtuemart_order_userinfos` WHERE `virtuemart_order_id` = 661 AND `address_type` = 'BT';
Result:
But as I said, nothing in the exported XML file.
As a test, I filled in this value in the column customer_note and added that in the export layout. This time the value is there. However, this is a textarea, so I'd like to use the auftragsnummer field, which is a text field.
Cheers!