User Defined Fields

Status
Not open for further replies.
C

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?
 
K

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

"cjbstudent" wrote:


> 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?
 
K

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

"cjbstudent" wrote:


> 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?
 
K

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

"cjbstudent" wrote:


> 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?
 
Status
Not open for further replies.
Top