Where CustomerAttribute value is stored?

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


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