Creating search items endpoint | NestJs, Typeorm

search-items.md

Endpoint to search keyword in the database.

async function getSearchedData (search:string){
  try {
    const searchData = return await this.connection
                                     .getRepository(UserEntity)
                                     .createQueryBuilder("user")
                                     .leftJoinAndSelect("user.roles", "roles")
                                     .where(
                                        "user.full_name LIKE :search OR user.username LIKE :search OR user.email LIKE :search",
                                        { search: `%${search}%` }
                                     )
                                     .getMany();
      return searchData
  } catch (error) {
     throw new InternalServerErrorException();
  }
}