Where CustomerAttribute value is stored?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
6 年 前
Hi,
I created a custom field in customer page.
To use it I need to read the data from database. I found the CustomerAttribute table that stores field definition, while CustomerAttributeValue doesn't store the field value.
Into which table is it stored? I can't find it anywhere.
Thank you
6 年 前
infinito62 wrote:
Hi,
I created a custom field in customer page.
To use it I need to read the data from database. I found the CustomerAttribute table that stores field definition, while CustomerAttributeValue doesn't store the field value.
Into which table is it stored? I can't find it anywhere.
Thank you


Try GenericAttributes
6 年 前
Tried, it's not there
6 年 前
infinito62 wrote:
Tried, it's not there


Was it an address field you created?
6 年 前
By default it should stay at "CustomerAttribute" and "CustomerAttributeValue" tables. If you create the field from http://localhost:15530/Admin/Setting/CustomerUser url.
6 年 前
CustomerAttributeValue behaves similar to product spec mapping. It contains item values related to attributes.
Values entered by user are stored elsewhere. There'no customerid field.
I need personal vat number, called diffrrently and not to be confused with vat. I need to transfer it to my erp in order to make invoices to private citizens. It'a text field.  Italian fiscal system is rather intricate.
6 年 前
Found.
It's hidden into genericattributes, with this structure

Entityid (customerid)
Keygroup "customer"
Key "CustomCustomerAttributes"
Value (xml structure that includes attribute id and related value)

Suggestion: build a sql function oherwise it'reaaly a nightmare.
6 年 前
Found.
It's hidden into genericattributes, with this structure

Entityid (customerid)
Keygroup "customer"
Key "CustomCustomerAttributes"
Value (xml structure that includes attribute id and related value)

Suggestion: build a sql function oherwise it'reaaly a nightmare.
5 年 前
I am trying to see where EU Cookie law accepted value is getting stored.it is not getting saved to database Generic Attribute table. Could you please give some insight on it?  Is it getting stored in cache of browser?
5 年 前
In Settings StoreInformationSettings.DisplayEUCookieLawWarning
See Settings -> All settings (advanced)
yourwebsite.com/Admin/Setting/AllSettings
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.