Child pages
  • Grouper loader SQL group list example
Skip to end of metadata
Go to start of metadata
Attribute nameValue
Source typeSQL
Loader typeSQL_GROUP_LIST
Database namejdbc
QuerySELECT '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 typeCRON
Cron schedule0 0 6 * * ?

Optional, if you want a group query, do something like this, and change the Query too

Attribute nameValue
QuerySELECT '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 querySELECT '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 typeaddIncludeExclude
  • No labels