Skip to main content
Solved

Export customer address data to Excel - SQL

  • November 21, 2022
  • 2 replies
  • 312 views
N
Do Gooder (Customer)
  • Nielf
  • Do Gooder (Customer)

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

Best answer by Link

Hi @Nielf 

of course you can export it from the database.

Use the view customer_info_address

 

View original

L
Superhero (Customer)
Forum|alt.badge.img+23
  • Link
  • Superhero (Customer)
  • November 21, 2022

Hi @Nielf 

of course you can export it from the database.

Use the view customer_info_address

 

Kind regards
A
Sidekick (Customer)
  • andjor
  • November 21, 2022

Dear

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

Best Regards,
André
 

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings