private List getRoomsOrganisationByOrganisationId(long organisation_id, int start, int max, String orderby, boolean asc){
try {
Object idf = PersistenceSessionUtil.createSession();
EntityManager session = PersistenceSessionUtil.getSession();
EntityTransaction tx = session.getTransaction();
tx.begin();
String hql = "select c from Rooms_Organisation as c " +
"where c.organisation.organisation_id = :organisation_id " +
"AND c.deleted <> :deleted";
if (orderby.startsWith("c.")){
hql += "ORDER BY "+orderby;