Don't miss out Virtual Happy Hour this Friday (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
Don't miss out Virtual Happy Hour this Friday (April 26).
Found out how it works. The table mcmd_SelectedEnumValue is the key.
To get all shipping addresses with Box in Line2 this is your code:
select * from cls_Address c
inner join mcmd_SelectedEnumValue s on s.[Key] = c.AddressType and s.Id = 2
where Line2 like '%box%'
Also described here:
https://world.episerver.com/forum/developer-forum/Episerver-Commerce/Thread-Container/2014/2/Customer-Billing-Address-in-SQL-Query/
/Kristoffer
Hi!
I would like to run a SQL script (not preferable and not recommended, I know!) that removes all shipping addresses with "Box" in Line2. But I don't understand the AddressType in cls_Address. It is a Guid and different for all addresses? I can't find any relation to another table either.
How can I find out which addresses are shipment addresses?
Thanks!
/Kristoffer