public Boolean isReportActive(Long repoSeqId) {
    IPersistenceService persistenceService =
        (IPersistenceService) ServiceLocator.findService("hibernatePesistenceService");
    ;
    List activeFlagList =
        persistenceService.executeQuery(
            " from "
                + EntityConstansts.ReportsAuthDetails
                + " where repoSeqid= "
                + repoSeqId
                + " and activeFlag = 0");

    if (activeFlagList != null && !activeFlagList.isEmpty()) {
      return false;
    }
    return true;
  }
  public List getAllAccessReports() throws ALNTApplicationException, ALNTSystemException {
    IPersistenceService persistenceService =
        (IPersistenceService) ServiceLocator.findService("hibernatePesistenceService");
    ;
    List accessReportsList =
        persistenceService.executeQuery(
            " from "
                + EntityConstansts.JiResourceFolder
                + " resFolder where resFolder.parentFolder in (select id from "
                + EntityConstansts.JiResourceFolder
                + " folder where folder.uri in ('/organizations/organization_1/reports/ACCESS','/organizations/organization_1/reports/ADHOC/ACCESS'))");
    // +"and resFolder.id not in (SELECT repoSeqid FROM "+ EntityConstansts.ReportsAuthDetails +"
    // where rad.activeFlag = 0))");

    /*List accessReportsList = persistenceService.executeQuery(" from "+EntityConstansts.JiResourceFolder+
    " resFolder where resFolder.parentFolder in (select id from "+EntityConstansts.JiResourceFolder + " folder where folder.uri in ('/reports/ACCESS','/reports/ADHOC/ACCESS'))" +
    		" and resFolder.id not in (SELECT repoSeqid FROM ReportAuthDetails where activeFlag = 0)");*/
    // List accessReportsList = persistenceService.executeQuery("select resFolder.label as label
    // from "+ EntityConstansts.JiResourceFolder +" resFolder where resFolder.uri in
    // ('/reports/ACCESS','/reports/ADHOC/ACCESS') ");

    return accessReportsList;
  }