Versions Compared

Old Version 7

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

compared with

New Version 8

changes.mady.by.user Chris Hyzer (upenn.edu)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
SELECT gg.name AS subject_identifier, 'g:gsa' AS subject_source_id 
FROM grouper_groups gg, grouper_aval_asn_asn_group_v gaaagv 
WHERE gg.name = 'test:attestation:autoAttestation:autoAttestationMembers' AND gg.id = gaaagv.group_id 
AND gaaagv.attribute_def_name_name1 = 'etc:attribute:attestation:attestation' 
AND gaaagv.attribute_def_name_name2 = 'etc:attribute:attestation:attestationCalculatedDaysLeft' AND gaaagv.value_string != '0'

...