Skip to content

Collection with set #3461

Open
Open
@analim111

Description

@analim111

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:









Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions