get Project Groups Ids

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

Method to execute the query to select the list of a Group's id of a project

Return

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

Parameters

projectId

The project from fetch the list