Vishal isharani
Vishal isharani
I'm also facing the same issue only difference is I'm using Postgres. ``` return this.getRepo().createQueryBuilder('job-card') .leftJoinAndMapOne('job-card.workflowState', qb => qb .from(WorkflowStateEntity, 'w') .orderBy({ 'w.createdAt': 'DESC' }) .limit(1), 'workflow', "workflow.job_card_id = job-card.id",...
@imnotjames Ok here's the generated sql. I will try to give you a reproduction with repository. But i'm not expert with unit testing (chai). ``` SELECT "job-card"."id" AS "job-card_id", "job-card"."created_at"...
@imnotjames due to project deadline I have fixed this other way using raw query.