...
Open a group, add a new report
| myReport | |
| my service users | |
| SQL | |
| SELECT gm.subject_id, gm.name, gm.description FROM grouper_memberships_lw_v gmlv, grouper_members gm WHERE gmlv.group_name = 'testB:testGroup2' AND gmlv.member_id = gm.id AND gmlv.subject_source = 'jdbc' ORDER BY 1 | |
| CSV | |
| 0 0 6 * * ? (run daily at 6am) | |
| usersOfMyService_$$timestamp$$.csv | |
| Yes, send email when the report is ready |
Make sure you have mail setup in grouper.properties:
...
Make sure you have a mailAttributeName in your person subject source
Make sure you have an encrypt.key in morphString.properties
| Code Block |
|---|
subjectApi.source.jdbc.param.emailAttributeName.value = email |
...