Filter and Query Catalog Events (Backend)

[michellelin1]

Instructions

• Modify the GET /catalog route so that takes in a req.query with fields title, subject, event_type, and year
  • Currently, the GET /catalog returns all rows in catalog, but we want to make the search functionality more robust
• Linked to frontend #24

Notes

• All the fields are optional (ex. If the user doesn’t specify a subject, you should include all subjects in your search)
• To match the title, use the LIKE operator (ex. title LIKE ‘%user_input%’)
• Order the events by title ASC

Acceptance Criteria

• Only return rows that match all the filters

Resources

• Postgres Like Operator
• Postgres Where Clause

As always, feel free to message Michael and Michelle if you have any questions!