Where CustomerAttribute value is stored?

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
6 years ago
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 years ago
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 years ago
Tried, it's not there
6 years ago
infinito62 wrote:
Tried, it's not there


Was it an address field you created?
6 years ago
By default it should stay at "CustomerAttribute" and "CustomerAttributeValue" tables. If you create the field from http://localhost:15530/Admin/Setting/CustomerUser url.
6 years ago
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 years ago
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 years ago
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 years ago
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 years ago
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.