add view for jwt creds

select gp.username, gm_user_to_email.subject_source as subject_to_email_source_id, gm_user_to_email.subject_id as subject_to_email_id, 

gm_user_to_email.email0 as email, to_timestamp(gp.expires_millis / 1000) as expires, gm_credential.subject_identifier0 credential_name

from grouper_password gp, grouper_members gm_user_to_email, grouper_members gm_credential

where gp.member_id_who_set_password  = gm_user_to_email.id

and gm_user_to_email.email0 is not null

and to_timestamp(gp.expires_millis  / 1000) > now()

and to_timestamp(gp.expires_millis  / 1000) < (now() + interval '14' day)

and gm_credential.id = gp.member_id ;