Where CustomerAttribute value is stored?

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


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