Description
Hello,
I am a bit stumped about getting Set in a collection.
Java:
Person.java
private Long uniqueId;
private String firstName;
private String lastName;
private Set alias; //using Set for uniqueness
Group.java
private Long uniqueId;
private String groupName;
private String description;
private List members;
Table: Person
unique_id | first_name | last_name | alias
1 | Jack | Johnson | Jake, JJ, Jacky
Table: Group
unique_id | name | description
1 | Drivers | A team of drivers
2 | Recruiters | A team of recruiters
Table: Group_Employee_Map
unique_id | group_id | person_id
1 | 1 | 2
2 | 2 | 14
Query:
select g.unique_id, g.name, g.description, p.first_name, p.last_name, gem.person_id as person_id, (......what go here for alias?...,)
from Group_Employee_Map gem
left join Person p on gem.person_id = p.unique_id
left join Group g on gem.group_id = g.unique_id
where g.first_name = 'Jack'
(......what go here for alias?...,)
Group.xml: