Cacher is the code snippet organizer for pro developers

self.getWorkItemsByParentId = function(pID) {
    var parameters = [pID];
    return DBA.query("SELECT * FROM workItems WHERE parentWorkItemID = (?) AND workItemTypeID != 7 AND workItemVSOState != 'Closed'", parameters)
        .then(function(result) {
            return DBA.getAll(result);
        });
};