nestjs-paginate JSONB support

JSONB support

Open VladimirTambovtsev opened this issue 2 years ago • 4 comments

How to use filterableColumns with Postgres JSONB ?


const assigned_bids = await paginate<Bid>(request, qb, {
        relations: ['product', 'statuses', 'basisBuyer'],
        sortableColumns: sortBy.map((e) => e[0]) as PaginateConfig<Bid>['sortableColumns'],
        searchableColumns: (request.searchBy as PaginateConfig<Bid>['searchableColumns']) || [],
        defaultLimit: 4,
        maxLimit: 500,
        where: { user: { id: In(assignedIds) } },
        filterableColumns: {
          year: [FilterOperator.EQ, FilterOperator.NOT, FilterOperator.IN],

          mass: [FilterOperator.EQ, FilterOperator.BTW, FilterOperator.GTE, FilterOperator.NOT, FilterOperator.IN],
          'basisBuyer.id': [FilterOperator.EQ],
          'product.nomenclatureGroupId': [FilterOperator.EQ],

          // deliveryDate is JSONB field in PostgreSQL. ex:
          /*
          {
            "to": "2022-06-26",
            "from": "2022-06-20"
          }
          */
          deliveryDate: [FilterOperator.EQ, FilterOperator.BTW, FilterOperator.IN]

       
        }

Thanks