Skip to content

请问如何通过Tag模糊查询获取所有包含该标签的文章列表 #51

@zhangsanplus

Description

@zhangsanplus

例如: 用户按标签查询,输入关键字 Javascript 获取如下结果


[
  {
    createdAt: "2020-01-14 15:51:24",
    updatedAt: "2020-04-13 14:35:55",
    id: 87,
    title: " React Hooks 笔记",
    content: "content值",
    viewCount: 66,
    tags: [{name: "Javascript", name: "react"}],
    categories: [{name: "Javascript"}],
    comments: []
  },
  {
    createdAt: "2020-01-14 15:51:24",
    updatedAt: "2020-04-13 14:35:55",
    id: 88,
    title: " React Hooks 笔记1",
    content: "content值",
    viewCount: 66,
    tags: [{name: "Javascript", name: "vue"}],
    categories: [{name: "Javascript"}],
    comments: []
  }
]
const { tag_name } = ctx.query
.....
const data = await ArticleModel.findAndCountAll({
   这个查询sql 该怎么写
})

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions