Just a reminder to myself that I found this nice little code snippet that we can use to find “OPEN” records through Java MBO’s.  “OPEN” in this case, I would assume, is something along the lines of a workorder with at status that is in WAPPR, APPR, INPRG, WMATL, WSCH and WPCOND.  Here is the code snippet:

SqlFormat sqf = new SqlFormat(getUserInfo(), “(reportedby = :1 and ” + ((WOService)getMboServer()).getCriteria(“OPEN”) + “)”);