Where CustomerAttribute value is stored?

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


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