BK
Size: a a a
BK
RA
RA
VS
IK
insert or update on table "user" violates foreign key constraint "FK_974590e8d8d4ceb64e30c38e051"
VS
VS
VS
IK
АП
K
export declare function Index(name: string, fields: string[], options?: IndexOptions): Function;
VS
VS
LK
let qb = this.jobRepository.createQueryBuilder('jobs');должно прийти 25 записей
qb = qb.leftJoinAndSelect(`jobs.spheres`, 'spheres');
qb = qb.offset(skip).limit(perPage);
const [results, count] = await qb.getManyAndCount();
qb = qb.leftJoinAndSelect(`jobs.spheres
, 'spheres');`speheres
это many to many, у джобы много тегов, у тега много джобspheres
, то мне возвращается 25 записейLK
innerJoinAndSelect
IK
LK
/**работает, но типа стремно это все
* Set's LIMIT - maximum number of rows to be selected.
* NOTE that it may not work as you expect if you are using joins.
* If you want to implement pagination, and you are having join in your query,
* then use instead take method instead.
*/
limit(limit?: number): this;
/**
* Sets maximal number of entities to take.
*/
take(take?: number): this;
IK