A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More.
AI OnAI Off
AddressType in cls_Address? [Commerce 12.16]
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
Edited,
Aug 30, 2019 12:01
This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.
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