model.Form.belongsToMany(model.Issue, { through: model.FormIssue,foreignKey:"formId",as:"formIssue"});
model.Issue.belongsToMany(model.Form, { through: model.FormIssue,foreignKey:"issueId",as:"issueForm"});model.FormIssue:
const FormIssue = app.model.define("fromIssue", {
id: { type: INTEGER, primaryKey: true, autoIncrement: true },
formId:{
type:INTEGER,
allowNull:false,
comment:"Id"
},
issueId:{
type:INTEGER,
allowNull:false,
comment:"Id"
},
createdAt: DATE,
updatedAt: DATE,
deletedAt : DATE,
});query:
let form=await ctx.model.Form.findOne({
where:{id:formId},include:[
{
model:ctx.model.Issue,
as:"formIssue"
},
]
}); there is no problem that the results can be found, and the list of formIssue questions queried by the question is not sorted according to the time of the formIssue table.
the query order is the same regardless of the chronological order of the operation.
I want the sequential sentence of the formIssue question list to be added to the createdAt sort of multiple pairs of tables, rather than according to the createdAt sort created by Issue itself
see on the Internet that order can be introduced into the model
so try:
let form=await ctx.model.Form.findOne({
where:{id:formId},include:[
{
model:ctx.model.Issue,
order:[[model.FormIssue,"createdAt","DESC"]]
as:"formIssue"
},
]
});is still invalid in the end, could you tell me how to solve it?