Help

How can I use SQL to find out which contacts have the Data Access flag turned on?

eden_cheng
Journeyman

How can I use SQL to find out which contacts have the Data Access flag turned on?

I would like to use SQL to build a report showing students who have withdrawn and whose contacts still have the Data Access flag enabled. Could you please let me know which tables and fields I should reference?

1 Solution
kkentk12
Hobbyist

Hi!

 

I believe it's on the Guardians table and the field is AllowWebAccess to see which guardians still have access.

 

The table has studentID so I would join on studentID and then filter on enroll status and allow web access

View solution in original post

1 Reply
kkentk12
Hobbyist

Hi!

 

I believe it's on the Guardians table and the field is AllowWebAccess to see which guardians still have access.

 

The table has studentID so I would join on studentID and then filter on enroll status and allow web access