| Attribute name | Value |
|---|---|
| Source type | SQL |
| Loader type | SQL_GROUP_LIST |
| Database name | jdbc |
| Query | SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup1' AS group_name FROM SUBJECT subject UNION SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup2' AS group_name FROM SUBJECT subject |
| Schedule type | CRON |
| Cron schedule | 0 0 6 * * ? |
...
| Attribute name | Value |
|---|---|
| Query | SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup1_systemOfRecord' AS group_name FROM SUBJECT subject UNION SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup2_systemOfRecord' AS group_name FROM SUBJECT subject |
| Group query | SELECT 'test:testGroup1_systemOfRecord' AS group_name FROM SUBJECT subject WHERE subjectId = 'test.subject.0' UNION SELECT 'test:testGroup2_systemOfRecord' AS group_name FROM SUBJECT subject WHERE subjectId = 'test.subject.0' |
| Group type | addIncludeExclude |