AnsweredAssumed Answered

SQL query for contact details page

Question asked by mohansrinivas on Nov 12, 2014
Latest reply on Jun 7, 2018 by dasja02

Hello All,

SD-12.7

 

We have an requirement to display all the contact detail information and that info has to contain  the fields availble in the contact detail page by running the SQL query.for eg, for user x the results should be which group ,whch accesss type,contact type,roles etc.in which the user x have been tagged to.

 

I have tried the below code but am not getting the results. Please help me in  framiong the query.

 

select ca_contact.contact_uuid, last_name,zagent_id,ca_location.location_uuid, ca_location.location_name,ca_location.zlmsid, 

ca_contact.inactive, ca_location.inactive              

from ca_contact


Regards,

Mohan

Outcomes