본문 바로가기

NEW(스크립트용)

any를 활용하여 database 내부 value 값이 array 일 때 filtering

  async searchKeyword(req: KeywordSearchReq): Promise<PostingKeywordResDto> {
    const result = new PostingKeywordResDto();
    result.ok = true;
    try {
      if (req.keyword !== undefined) {
        this.postings.createQueryBuilder('Posting').where(''); //any
        let searchResul = await this.postings
          .createQueryBuilder('Postings')
          .where(`'` + req.keyword + `' = ANY(keyword)`)
          .getMany();
        result.postingList = searchResul;
        console.log(searchResul);
      }
    } catch (ex) {
      console.log(ex);
      result.ok = false;
      result.error = ex;
    }
    return result;
  }