Accessing Database Extensions?

[coletarbet]

Is it possible to access custom / extended fields while connected to the Students table?

I tried adding them to the projection, but that doesn't work.

students_table = ps_connection.get_schema_table('students')
    params = {
        'q': f'enroll_status==0;id=={id}',
        #'projection': 'dcid,id,first_name,last_name,[S_STU_CRDC_X]DualEnrollment_YN',
        'projection': 'dcid,id,first_name,last_name,S_STU_CRDC_X.DualEnrollment_YN',
    }

More extended field examples:

StudentCoreFields.act_date
U_StudentsUserFields.studentemail
S_STU_CRDC_X.DualEnrollment_YN

[cbini]

Hey @coletarbet! You need to query extension tables individually. For example:

ps_connection.get_schema_table('S_STU_CRDC_X')

Make sure your plug-in includes that table and fields for reading.

[coletarbet]

Ok thanks!