WebCOBRA.com Community Message Boards

tbbmanager
Posts: 4
Since: 10/13/2009

Hi,

I am trying to get contact information and was told that the relational API could provide this, but when i go into the client/employers section i cannot find this information in the database. I had opened a ticket with support on this Travis Support Case 40755 - Client Reports and was told to go here. Please assist.

Paul

sszelei
Posts: 53
Since: 09/02/2009

Paul

Contact information may be obtained using the the SystemInformationLinkTable along with Phones and or Addresses tables.

ie:
select ModuleIdent, number from SystemInformationLinkTable silt2
join dbo.Phones ph on silt2.TableLinkIdent = ph.PhoneID
and silt2.InformationTypeID = 3 and ph.DELETED = 0 AND ph.PhoneTypeID = 4
join QB on qb.QBAutoId = silt2.ModuleIdent
where silt2.ModuleTypeID = 3
AND silt2.DELETED = 0


Hope this helps.

Regs,

Steven

tbbmanager
Posts: 4
Since: 10/13/2009

How do i get this in the access DB though?

sszelei
Posts: 53
Since: 09/02/2009

Sorry, I don't understand the question. Are you asking for the exact query for Access? The query provided is one that shows the tables and how to link them.

Regs,

Steven