[nestjs, sql] typeorm으로 동적 where 조건문 생성하기(동적 쿼리 생성)

 

        //null을 제외한 where조건문 생성 - 동적 쿼리 생성 
        var whereQuery = {}
        if(req.lcategory)
          whereQuery['lcategory'] = req.lcategory
        if(req.mcategory)
          whereQuery['mcategory'] = req.mcategory
         if(req.scategory)
          whereQuery['scategory'] = req.scategory
        let searchTotalGuide = await getRepository(FoodGuide).find({
          relations:['addAdmin','editAdmin'],
          where: whereQuery,
          order: {
            createdAt: 'DESC',
          },
        });
        result.guidList = searchTotalGuide;
        result.ok = true;