sequelize:Sequelize.where(Sequelize.col(`table.name`), { [Op.like]: `%${value}%` })
mysql:where table.name LIKE %value%
sequelize:Sequelize.where(Sequelize.col(`table.name`),value)
mysql:where table.name=value
const { dir = '/public', queryConditions = null } = ctx.request.query
const Opthion = {
include: [
{
model: sequelize.model('FileDataInfo'),
as: 'fileInfo',
where: {
private: false,
}
}
],
where: {
dir: dir,
[Op.or]: [
Sequelize.fn(
'JSON_CONTAINS',
Sequelize.col('tags'),
JSON.stringify({
tag: queryConditions,
})
),
Sequelize.where(Sequelize.col(`fileInfo.fileName`), { [Op.like]: `%${queryConditions}%` })
]
}
}
const fileSharingCopyList = await fileSharingCopyService.findAll(Opthion)