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 |