Hi, I have exported a solution from my test enviroment and imported to my production enviroment as Unmanaged solution (I used the same approach when importing the solution from DEV to TEST), all changes have been published. I've added a new attribute to my Contact entity with som JScript code.
It is working fine - I can see the new attribute on the form, it contains data (i can find records via advanced find), when I change the value JScript reacts as expected, I can explore details throug XRMToolbox Metadata Browser...
But... I can't find the attribute in database. I cannot see it in dbo.FilteredContact view, it is not in the dbo.ContactExtensionBase table, I cannot find the attribute in metadataschema.Attributes table.
I have the System Administrator role in CRM, I've checked the DB with the domain admin account.
The question is - where are the data stored in my database? For the reporting reason I need a databse acces to this attribute.
I use theese select commands:
SELECT activityid FROM dbo.FilteredContact WHERE [MyOrgName]_[MyAttName] = 'some value'
or
SELECT activityid FROM dbo.ContactExtensionBase WHERE [MyOrgName]_[MyAttName] = 'some value'
In dev/test enviroments it works, in production enviroment it doesn't work. Any ideas why?
