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.
Thread starter Similar threads Forum Replies Date
S User Defined Fields adding new value (2) Using Outlook 0
M vCard does not have user-defined fields from my custom contact form (365) Using Outlook 1
F MAPI, User Defined Fields and perspective after 20 years Outlook VBA and Custom Forms 0
B Outlook Business Contact Manager with SQL to Excel, User Defined Fields in BCM don't sync in SQL. Can I use VBA code to copy 1 field to another? BCM (Business Contact Manager) 0
M Multiple User Defined Fields that can be added, changed, updated using VBA and user form Outlook VBA and Custom Forms 0
R User Defined Fields adding new value Using Outlook 3
S VBA with User Defined fields Outlook VBA and Custom Forms 9
M Map Outlook user defined fields onto a Sharepoint list ??? Outlook VBA and Custom Forms 1
N How to retrieve user defined fields values to bcm form. Using Outlook 2
N How to disable user defined fields in BCM forms Using Outlook 2
K User Defined Fields in Outlook 2010 Using Outlook 2
P User-Defined Relationship Fields: Invisible? BCM (Business Contact Manager) 0
W Template to produce calendars with wrapped text & user-defined fields? Using Outlook 1
R writing "Instant Search" queries to find User-Defined fields Using Outlook 0
P Joining the User Defined Fields to their User Field<n> counterpart BCM (Business Contact Manager) 0
E Accessing User Defined Fields in BCM Database part 2 BCM (Business Contact Manager) 0
E [SOLVED] Accessing User Defined Fields in BCM Database part 1 BCM (Business Contact Manager) 9
T User-defined fields in Outlook to be incorporated into Mail Merge documents Using Outlook 1
E user defined fields (empty) Using Outlook 3
J User Defined Fields Outlook VBA and Custom Forms 6
J user defined fields Outlook VBA and Custom Forms 2
P Where are User-defined fields stored in BCM 2010 database? BCM (Business Contact Manager) 2
M User defined fields Outlook VBA and Custom Forms 6
J User defined fields with pre-defined values Outlook VBA and Custom Forms 3
J Where does BCM store User-Defined fields in the database? BCM (Business Contact Manager) 3
D User-defined fields and multiple forms BCM (Business Contact Manager) 1
T User Defined Fields vs. Area of Interest BCM (Business Contact Manager) 1
B User defined field for messages with 'me' in the [To], [Cc] line Using Outlook 0
R Creating a user defined function Outlook VBA and Custom Forms 3
M Compile error: User-defined type not defined Outlook VBA and Custom Forms 0
C Outlook 2016 Conditional Format for User Defined Field Using Outlook 1
N How to set automatically the default or user defined Quickstyle Templates by Answer in Outlook Using Outlook 1
Daniel Schunk User-defined form arrives empty at the recipient Using Outlook 3
J Assess content of User Defined Field in Rule Using Outlook 3
S Outlook User defined date field (UDF) not syncing Using Outlook 2
G how can Apply User-defined Field to all Sub Folder and Other Using Outlook 14
F Adding User Defined Field to another form Using Outlook 0
G How to let data in an account user defined field appear in the same field all related opportunities BCM (Business Contact Manager) 1
V Extracting user-defined details from a public folder Outlook VBA and Custom Forms 2
J How to show the "value" of a user-defined Account field in a Contact Record BCM (Business Contact Manager) 2
witzker Outlook bug when creating a user defined contact form? Using Outlook 1
Wotme Syntax for user defined field in VBA Using Outlook 1
J How to create a user defined dropdown list field for a custom contact form Using Outlook 3
S User defined field not showing in Custom view Exchange Server Administration 0
T issue/ base and user defined contact types BCM (Business Contact Manager) 2
D User Defined Info Gone Using Outlook 1
S [SOLVED] Search by User-Defined Relationship Field BCM (Business Contact Manager) 2
C User defined field not found in any views prints. Cannot locate to delete. Using Outlook 2
M Populating a user-defined field in outlook form using Excel Cell value from VB Using Outlook 1
M user-defined properties in printed emails? Outlook VBA and Custom Forms 8
Similar threads


















































Top