You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 5
Next »
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 UNION SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup2' AS group_name FROM SUBJECT |
Schedule type | CRON |
Cron schedule | 0 0 6 * * ? |
Optional, if you want a group query, do something like this, and change the Query too
Attribute name | Value |
---|
Query | SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup1_systemOfRecord' AS group_name FROM SUBJECT UNION SELECT 'jdbc' AS subject_source_id, subjectId AS subject_id, 'test:testGroup2_systemOfRecord' AS group_name FROM SUBJECT |
Group query | SELECT 'test:testGroup1_systemOfRecord' AS group_name FROM SUBJECT WHERE subjectId = 'test.subject.0' UNION SELECT 'test:testGroup2_systemOfRecord' AS group_name FROM SUBJECT WHERE subjectId = 'test.subject.0'; |
Group type | addIncludeExclude |