case view query methods