workorder.category (String) which holds the name of the category.
category.department (String) the department the category belongs to.
If given a department name, is there an easy way to filter all the workorder that has that department?
workorder holds the category name, and category holds the department name. I am not sure how to link these two tables together to do this search.