NEW(스크립트용)
any를 활용하여 database 내부 value 값이 array 일 때 filtering
maggieH
2022. 7. 25. 14:24
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;
}