moving dashboard ticket queries from dashboard helper