Listing all contacts in the People TAB of the super case.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Listing all contacts in the People TAB of the super case.
Document ID : 000-000951 Created: 2/23/2005 Last changed on: 2/23/2005

The CCMNK table holds the contact names and contact data of the entries listed in the People TAB of the Super Case screen.
The relation between the SCDNK (super case) table and the CCMNK (Contact data) table is a many:many relation. The SCLNK table is used to implement the many to many relation.
The object type must be defined in the SourceFile field of the SCLNK table since the SCLNK table is used to link many types of objects. Use sclnk.SourceFile = 'CCM' to select contact objects.

Example link:
sclnk.SCDSiteID = scdnk.SCDSiteID
sclnk.SCDSysID = scdnk.SCDSysID
sclnk.UpSiteID = ccmnk.CCMSiteID
sclnk.UpSysID = ccmnk.CCMSysID
sclnk.SourceFile = 'CCM'

Example SQL:
select scd.SCDSiteID,scd.SCDSysID,scd.Address,ccm.FirstName AS "Respondent First Name",ccm.LastName AS "Respondent Last Name", scl.SCLtype AS Role from scdnk as scd
left outer join sclnk as scl ON
scl.SCDSiteID = scd.SCDSiteID AND scl.SCDSysID = scd.SCDSysID
left outer join ccmnk as ccm ON
scl.UpSiteID = ccm.CCMSiteID AND scl.UpSysID = ccm.CCMSysID AND scl.SourceFile = 'CCM'

Example SQL 2:
Same as above except that the list is conditioned by a type of role.
In this case when the role = 'Responded'. This is implemented by adding the join condition:
scl.SCLtype = 'Respondent'

select scd.SCDSiteID,scd.SCDSysID,scd.Address,ccm.FirstName AS "Respondent First Name",ccm.LastName AS "Respondent Last Name", scl.SCLtype AS Role from scdnk as scd
left outer join sclnk as scl ON
scl.SCDSiteID = scd.SCDSiteID AND scl.SCDSysID = scd.SCDSysID AND scl.SCLtype = 'Respondent'
left outer join ccmnk as ccm ON
scl.UpSiteID = ccm.CCMSiteID AND scl.UpSysID = ccm.CCMSysID AND scl.SourceFile = 'CCM'

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.