时间戳

首页 > 解决方案 > 仅搜索按列分组的最后记录

javascript - 仅搜索按列分组的最后记录

问题描述

我想只带上根据旅行（id_travel_fk）按车辆（描述）分组的最新信息

我有以下查询

const vehiclesStates = await this.pg.reg_vehicles_states
    .createQueryBuilder("rvs")
    .select([
      "rvs.registration_date", "rvs.finish_date", "rvs.duration",
      "rv.description", "rv.external_id", "rv.license_plate",
      "tvt.type",
      "rt.registration_date", "rt.external_id", "rt.num_doc", "rt.load_label", "rt.description",
      "rd.name", "rd.external_id",
      "rlo.name", "rlo.address", "rlo.number", "rlo.district", "rlo.cep", "rlo.complement",
      "rlo.latitude", "rlo.longitude", "rlo.description", "rlo.external_id",
      "rld.name", "rld.address", "rld.number", "rld.district", "rld.cep", "rld.complement",
      "rld.latitude", "rld.longitude", "rld.description"," rld.external_id",
      "tvst.type"
    ])
    .leftJoin("rvs.travel", "rt")
    .innerJoin("rvs.vehicle", "rv")
    .innerJoin("rv.type", "tvt")
    .leftJoin("rt.driver", "rd")
    .leftJoin("rt.destination", "rld")
    .leftJoin("rt.origin", "rlo")
    .innerJoin("rvs.type", "tvst")
    .getMany();

使用以下查询返回带来所有银行记录..

目的是只带来前 4 条记录，如图所示。按车辆（描述）对数据进行分组，并仅将引用到列的最后记录（id_travel_fk）

有人可以帮我吗？

标签： javascriptpostgresqltypeorm

解决方案

推荐阅读