": "Pampulha - MG",
         "numberOfMouths": null,
         "shakingModel": null,
         "productType": "A",
         "registrationType": "V",
         "tankCapacity": null,
         "active": true,
         "createdAt": "2020-02-27T15:35:32.931Z",
         "updatedAt": "2020-02-27T15:35:32.931Z",
         "idPlaque": 1
       },
       {
         "plaque": "LSJ0023",
         "description": "Arraial dos Lucas",
         "numberOfMouths": null,
         "shakingModel": null,
         "productType": "A",
         "registrationType": "T",
         "tankCapacity": null,
         "active": true,
         "createdAt": "2020-02-27T15:45:00.042Z",
         "updatedAt": "2020-02-27T15:45:00.042Z",
         "idPlaque": 2
       }
     ]
   }

And if I pass skip 0 and take 2 return the both registers normally. Ok.. But I have filters and searchs in this. I can search by the plaque by example.. I tried to do with 'create query builder' all works less than pagination.. The code of typeorm is:

const compositions = await createQueryBuilder(Composition, 'composition')
                   .leftJoinAndSelect('composition.plaques', 'plaques')
                   .where(`composition.status <> 1 AND ${filterAndSearchOptions.where} ORDER BY ${filterAndSearchOptions.orderBy} ${filterAndSearchOptions.direction}${filterAndSearchOptions.pagination}`,
                       filterAndSearchOptions.params)
                   .getMany();

the variable filterAndSearchOptions do the controll of search and filters.. but when I pass skip 0 and take 1 then return only one register with only one plaque.. Because it is a many to many relation..

it returns:

{
     "status": 2,
     "createdAt": "2020-02-27T15:46:00.349Z",
     "updatedAt": "2020-02-27T15:46:00.349Z",
     "idComposition": 1,
     "plaques": [
       {
         "plaque": "HGW4865",
         "description": "Pampulha - MG",
         "numberOfMouths": null,
         "shakingModel": null,
         "productType": "A",
         "registrationType": "V",
         "tankCapacity": null,
         "active": true,
         "createdAt": "2020-02-27T15:35:32.931Z",
         "updatedAt": "2020-02-27T15:35:32.931Z",
         "idPlaque": 1
       }
     ]
   }

and if i pass skip 1 and take 1 it returns :

{
     "status": 2,
     "createdAt": "2020-02-27T15:46:00.349Z",
     "updatedAt": "2020-02-27T15:46:00.349Z",
     "idComposition": 1,
     "plaques": [
     {
         "plaque": "LSJ0023",
         "description": "Arraial dos Lucas",
         "numberOfMouths": null,
         "shakingModel": null,
         "productType": "A",
         "registrationType": "T",
         "tankCapacity": null,
         "active": true,
         "createdAt": "2020-02-27T15:45:00.042Z",
         "updatedAt": "2020-02-27T15:45:00.042Z",
         "idPlaque": 2
       }
     ]
   }

The same register but only the plaque different

I wanted to know a way to do a pagination with the second way.. :x Sorry by the text..

I have no idea how to do this in sql or typeorm.. Im losted.. kk

Here are one example:

this get one register and skip none

Running it:
https://example-pagination.herokuapp.com/products?skip=0&pageSize=2

Notice that it return the same register with 2 categories..

I wanted that returns two products

And this show the records in database:
https://example-pagination.herokuapp.com/products

And this is the code for these endpoins:

let where = '1=1';

   if(q.pageSize && q.skip){
     where = 1=1 LIMIT ${q.pageSize} OFFSET ${q.skip};
   }

   const ps = await createQueryBuilder(Product, 'product')
   .leftJoinAndSelect('product.categories', 'categories')
   .where(where)
   .getMany();
   return ps;

Its a simple example to explain my question.. And if u know how I can do a respect of this..

Either do/investigate one of the following:

a subquery instead of join. Grouping, or two separate selects and enrich in application memory.

всем привет ребята! что не так

QueryFailedError: invalid input syntax for type uuid: "{"id":"30fe9951-6a55-4921-a9c8-b2a4f3779744"}"

QueryFailedError: invalid input syntax for type uuid: "{"id":"30fe9951-6a55-4921-a9c8-b2a4f3779744"}"

Переведите ошибку

Короче говоря у меня айдишник типа uuid. Когда пытаюсь

findOne(
{where: {id: is} }
)

то ругается что не может сделать запрос