How do I access the Other's contact type's specific contact type via the database.
Other(Notary)
Other(Tax Collector)
Thanks,
Tim
Other Contact Types
Moderator: Lisa Ennis
-
- Posts: 7
- Joined: Fri Jan 06, 2017 9:50 am
- Contact:
Re: Other Contact Types
The pfm.Contact table has a field "OtherType" which has this value for other contact types (ContactType=16).
SELECT OtherType, [Name] FROM pfm.Contact WHERE ContactType = 16
SELECT OtherType, [Name] FROM pfm.Contact WHERE ContactType = 16
Brandon Ritchie
Reports Technical Team Lead
SoftPro
Reports Technical Team Lead
SoftPro
-
- Posts: 84
- Joined: Thu Sep 11, 2008 1:57 pm
Re: Other Contact Types
It is in the pfm.Contact table, the field is OtherType. It is the last field in the Select statement below.
Hope this helps!
Code: Select all
SELECT
C.RootId#,
C.Id#,
C.LastId#,
C.Code,
C.ContactType,
C.Name,
C.NameShort,
C.OtherType
FROM
pfm.[Contact] AS C
Lisa Ennis
Senior Report Developer
SoftPro
Senior Report Developer
SoftPro