backend/com.tecknobit.brownie.services.hostservices.repositories/HostServicesRepository/getServices

get Services

@Query(value = ""SELECT * FROM " + SERVICES_KEY + _WHERE_ + "( " + "MATCH(" + NAME_KEY + "," + PID_KEY + ") AGAINST (:" + KEYWORDS_KEY + _IN_BOOLEAN_MODE + ") " + "OR :" + KEYWORDS_KEY + " = ''" + ") " + "AND " + STATUS_KEY + " IN (:" + STATUSES_KEY + ") " + "AND " + HOST_IDENTIFIER_KEY + "=:" + HOST_IDENTIFIER_KEY", nativeQuery = true )

abstract fun getServices(@Param(value = "host_id") hostId: String, @Param(value = "keywords") keywords: String, @Param(value = "statuses") statuses: List<String>, pageable: Pageable): List<BrownieHostService>

Query used to count the services related to a host

Return

the services related to a host as List of BrownieHostService

Parameters

hostId

The identifier of the host

keywords

The keywords used to filter the results

statuses

The statuses used to filter the results

pageable

The parameters to paginate the query