You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 6
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 |