get Group Projects Ids

@Modifying(clearAutomatically = true )
@Query(value = ""SELECT " + PROJECT_IDENTIFIER_KEY + " FROM " + PROJECTS_GROUPS_TABLE + " WHERE " + GROUP_IDENTIFIER_KEY + "=:" + GROUP_IDENTIFIER_KEY", nativeQuery = true )
abstract fun getGroupProjectsIds(@Param(value = "group_id") groupId: String): List<String>

Method to execute the query to select the list of a Project's id of a group

Return

the list of projects ids of a group as List of String

Parameters

groupId

The group from fetch the list