User Defined Fields

[cjbstudent]

Does anyone know how to query the user defined fields in the BCM SQL
database. I have found the table called "ContactUserFields" but all entries
appear in Binary and I cannot extract them for use?

[k99ja04]

I wrote a post in response to a more recent question so see that. But I
would query the predefined views. You want the ones with IMAPIView in the
title. i.e. ContactIMAPIView. Then in your query cast them to the
appropriate datatype.

SELECT CAST(UserField1 as nvarchar(50)) as IndustryName
FROM AccountIMAPIVIEW

Post by cjbstudent
Does anyone know how to query the user defined fields in the BCM SQL
database. I have found the table called "ContactUserFields" but all entries
appear in Binary and I cannot extract them for use?