Business
Jobs
  • About Us
  • Solutions
    • Job Postings
      Post your job and receive qualified candidates in 48h.
    • Candidate Assessments
      500+ technical and psychological tests, plus anti-fraud.
    • Headhunting
      Tailor-made executive search from start to finish.
    • Payroll + EOR
      Payroll dispersal and EOR across 15+ LATAM countries.
  • Pricing
  • Jobs

0

441
Views
How to access all the rows whose 2 columns have similar values in these rows in Node Js Sequelize

I am using Node Js, MySql (Sequelize) as my backend. In the image their are three rows against same TeacherId. I want to get the record where TeacherId, SubjectId AND CurriculumId are the SAME

as like this:

"data": [
    {
        "CurriculumId": 1,
        "curriculum_name": "UK National Curriculum",
        "SubjectId": 6,
        "subject_name": "Anatomy",
        "doc": [
            {
                "id": 18,
                "name": "abc.zip",
                "path": "https://www.google.com",
                "size": "163 KB",
                "createdAt": "2021-12-30T18:58:52.000Z"
            },
            {
                "id": 21,
                "name": "abcc.sql",
                "path": "https://www.oogle.com",
                "size": "1613 KB",
                "createdAt": "2021-12-30T18:58:52.000Z"
            },
        ]
    },
    {
        "CurriculumId": 2,
        "curriculum_name": "EYFS",
        "SubjectId": 4,
        "subject_name": "Statistics",
        "doc": [
            {
                "id": 23,
                "name": "1642770387740-file-example_PDF_1MB.pdf",
                "path": "https://app.edukko.com/api/uploads/teacherDocuments/1642770387740-file-example_PDF_1MB.pdf",
                "size": "1018.00 KB",
                "createdAt": "2022-01-21T13:06:27.000Z"
            }
        ]
    }
]

Any help will be much appreciated. Thanks.

about 4 years ago · Juan Pablo Isaza
Answer question
Find remote jobs

Discover the new way to find a job!

Top jobs
Top job categories
Business
Post vacancy Pricing Sales
Legal
Terms and conditions Privacy policy
© 2026 PeakU Inc. All Rights Reserved.
Andres GPT
Show me some job opportunities
There's an error!