get
Applications
@Query(value = "SELECT DISTINCT a.* FROM " + APPLICATIONS_KEY + " AS a" +
" LEFT JOIN " + PLATFORMS_KEY + " as p ON" +
" p." + APPLICATION_IDENTIFIER_KEY + "=" + IDENTIFIER_KEY +
" WHERE " + NAME_KEY + " LIKE %:" + NAME_KEY + "%" +
" AND (" +
"COALESCE(:" + PLATFORMS_KEY + ") IS NULL OR " +
"p." + PLATFORM_KEY + " IN (:" + PLATFORMS_KEY + ")" +
") " +
" ORDER BY " + CREATION_DATE_KEY + " DESC",
nativeQuery = true
)
Method to execute the query to get the applications list registered in the system
Parameters
name
The application name used as filter
platforms
The list of platforms used as filter
pageable
The parameters to paginate the query