Solved

Export customer address data to Excel - SQL

  • 21 November 2022
  • 2 replies
  • 217 views

  • Do Gooder (Customer)
  • 0 replies

Hi, 

I am trying to export at list of customers to Excel. However, I can see that I am limited to these columns fro the customer table:

Is i possible, using an advanced SQL query, to include the address columns of Address Identity ‘10’ in the export? 
 


Br,
Nielf

icon

Best answer by Link 21 November 2022, 12:17

View original

2 replies

Userlevel 7
Badge +22

Hi @Nielf 

of course you can export it from the database.

Use the view customer_info_address

 

Userlevel 2
Badge +8

Dear

I did a quick report for this. This you can Export direct to Excel.

Best Regards,
André
 

Reply