Point of Contact Table
Posted: Wed Oct 02, 2019 1:07 pm
Hello,
I am looking for some clarification to provide to me developer who is working on our website integration app with SP Select. Below is what the team has sent me and attached is examples of what they are seeing from the Point of Contact tables. Thank you in Advance for any light you can shed on this.
While implementing the logic for adding the selected contact types to an order, we would like to know more on the SoftPro SelectDB behavior for Contact & Person.
We observed PointOfContact table is used to map for Contact and Person, however it is observed that NULL value is getting set here and hence the interconnection between Contact & Person is not getting fetch successfully.
we are using the below query. Here [pfm].[PointOfContact] table is used to map the tables [pfm].[Person] and [pfm].[Contact]. But mapping data are missing in the table [pfm].[PointOfContact]. Please find the attached document containing the details of the same.
select p.RootId#,pc.RootId#,p.email,
p.Id#,pc.Id#,pc.ContactId$,cc.PreferredEmail,cc.ContactType,
p.LastId#,pc.LastId#,p.Email
from [pfm].[Person] p
left join [pfm].[PointOfContact] pc
on p.RootId#=pc.RootId#
and p.Id#=pc.PersonId$
left join [pfm].[Contact] cc
on pc.RootId#=cc.RootId#
and pc.ContactId$=cc.Id#
--and p.Id#=pc.Id#
--and p.LastId#=pc.LastId#
where p.rootid#=-2147483620
I am looking for some clarification to provide to me developer who is working on our website integration app with SP Select. Below is what the team has sent me and attached is examples of what they are seeing from the Point of Contact tables. Thank you in Advance for any light you can shed on this.
While implementing the logic for adding the selected contact types to an order, we would like to know more on the SoftPro SelectDB behavior for Contact & Person.
We observed PointOfContact table is used to map for Contact and Person, however it is observed that NULL value is getting set here and hence the interconnection between Contact & Person is not getting fetch successfully.
we are using the below query. Here [pfm].[PointOfContact] table is used to map the tables [pfm].[Person] and [pfm].[Contact]. But mapping data are missing in the table [pfm].[PointOfContact]. Please find the attached document containing the details of the same.
select p.RootId#,pc.RootId#,p.email,
p.Id#,pc.Id#,pc.ContactId$,cc.PreferredEmail,cc.ContactType,
p.LastId#,pc.LastId#,p.Email
from [pfm].[Person] p
left join [pfm].[PointOfContact] pc
on p.RootId#=pc.RootId#
and p.Id#=pc.PersonId$
left join [pfm].[Contact] cc
on pc.RootId#=cc.RootId#
and pc.ContactId$=cc.Id#
--and p.Id#=pc.Id#
--and p.LastId#=pc.LastId#
where p.rootid#=-2147483620