backend/com.tecknobit.pandoro.services.projects.repositories/ProjectsRepository/getAuthoredProjects

get Authored Projects

@Query(value = "SELECT * FROM " + PROJECTS_KEY + " WHERE " + AUTHOR_KEY + "=:" + AUTHOR_KEY + " ORDER BY " + CREATION_DATE_KEY + " DESC ", nativeQuery = true )

abstract fun getAuthoredProjects(@Param(value = "author") userId: String): List<Project>

Method to execute the query to select the list of a Project authored by the user id

Return

the list of projects as List of Project

Parameters

userId

The user identifier