I'm trying to create custom and ad hoc BCM queries using SQL Server's Query Analyzer.
I created 2 new User Defined fields for contacts in BCM such as:
Shoe Preference (text)
Hat Preference (text)
The values for these fields appear in the UserFieldDefinitions.FieldName column as expected.
I populate values for contacts such as:
Oxford and Wingtip for Shoe Preference
Fedora and Stetson for Hat Preference
By searching the DISTINCT CAST values of the dbo.UserFields table, I am able to determine that these Shoe and Hat Preference values are stored in UserField6 and UserField8, for example.
Is there a way to create an ad hoc query, executable from Query Analyzer, that joins these UserFields.UserField<N> values to their corresponding UserFieldDefinitions.FieldName columns?
In other words:
If the database were completely empty of any contact related data (Oxford and Wingtip have not yet been entered for any contacts), how can I tell from Management Studio/Query Analyzer that UserFields.UserField6 is used for the UserFieldDefinitions.FieldName value of "Shoe Preference" within BCM?
I created 2 new User Defined fields for contacts in BCM such as:
Shoe Preference (text)
Hat Preference (text)
The values for these fields appear in the UserFieldDefinitions.FieldName column as expected.
I populate values for contacts such as:
Oxford and Wingtip for Shoe Preference
Fedora and Stetson for Hat Preference
By searching the DISTINCT CAST values of the dbo.UserFields table, I am able to determine that these Shoe and Hat Preference values are stored in UserField6 and UserField8, for example.
Is there a way to create an ad hoc query, executable from Query Analyzer, that joins these UserFields.UserField<N> values to their corresponding UserFieldDefinitions.FieldName columns?
In other words:
If the database were completely empty of any contact related data (Oxford and Wingtip have not yet been entered for any contacts), how can I tell from Management Studio/Query Analyzer that UserFields.UserField6 is used for the UserFieldDefinitions.FieldName value of "Shoe Preference" within BCM?