private long getPracticePreferenceInt(String field) throws IOException { RcopiaDb db = getDb(PRACTICE_PREFERENCES); String query = "SELECT " + field + " FROM " + db.getName() + " WHERE " + PRACTICE_ID + "=" + user.getPracticeID(); long groupID = user.getGroupID(); if (groupID != 0) query += " AND " + PROVIDER_GROUP_ID + "=" + groupID; return db.getInt(query); }