Examples of FilterCriteria

com.sun.data.provider.FilterCriteria
org.openhab.core.persistence.FilterCriteria
This class is used to define a filter for queries to a {@link PersistenceService}.
It is designed as a Java bean, for which the different properties are constraints on the query result. These properties include the item name, begin and end date and the item state. A compare operator can be defined to compare not only state equality, but also its decimal value (<,>).

Additionally, the filter criteria supports ordering and paging of the result, so the caller can ask to only return chunks of the result of a certain size (=pageSize) from a starting index (pageNumber*pageSize).

All setter methods return the filter criteria instance, so that the methods can be easily chained in order to define a filter. @author Kai Kreuzer @since 1.0.0
org.tcm1998.accat.ItemFilter.FilterCriteria
@author tcm1998

Examples of com.sun.data.provider.FilterCriteria

    
    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();
        
        int idx=0;
        FilterCriteria firstName = null;
        FilterCriteria firstNameMax = null;
        if (firstNameFilter.getText() != null &&
                ((String)firstNameFilter.getText()).length() > 0) {
            firstName = new CompareFilterCriteria(
                    new FieldKey("firstName"), firstNameFilter.getText(),
                    false, true, true);
            idx++;
            firstNameMax = new CompareFilterCriteria(
                    new FieldKey("firstName"), firstNameFilter.getText()+"z",
                    true, false, false);
            idx++;
        }
        
        FilterCriteria lastName = null;
        FilterCriteria lastNameMax = null;
        if (lastNameFilter.getText() != null &&
                ((String)lastNameFilter.getText()).length() > 0) {
            lastName = new CompareFilterCriteria(
                    new FieldKey("lastName"), lastNameFilter.getText(),
                    false, true, true);
            idx++;
            lastNameMax = new CompareFilterCriteria(
                    new FieldKey("lastName"), lastNameFilter.getText()+"z",
                    true, false, false);
            idx++;
        }


        FilterCriteria email = null;
        FilterCriteria emailMax = null;
        if (emailFilter.getText() != null &&
                ((String)emailFilter.getText()).length() > 0) {
            email = new CompareFilterCriteria(
                    new FieldKey("email"), emailFilter.getText(),
                    false, true, true);

View Full Code Here

Examples of com.sun.data.provider.FilterCriteria


    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();        
        int idx=0;
        
        FilterCriteria nameFilter = null;
        FilterCriteria nameMaxFilter = null;
        if (name.getText() != null &&
                ((String)name.getText()).length() > 0) {
            nameFilter = new CompareFilterCriteria(
                    new FieldKey("organisationName"), name.getText(),
                    false, true, true);
            idx++;
            nameMaxFilter = new CompareFilterCriteria(
                    new FieldKey("organisationName"), name.getText()+"z",
                    true, false, false);
            idx++;
        }
        
        FilterCriteria partnershipFilter = null;
        if (partnership.getValue() != null &&
                ((String)partnership.getValue()).length() > 0) {
            partnershipFilter = new CompareFilterCriteria(
                    new FieldKey("typeOfPartnership"), partnership.getValue());
            idx++;
        }
        
        FilterCriteria emailFilter = null;
        FilterCriteria emailMaxFilter = null;
        if (email.getText() != null &&
                ((String)email.getText()).length() > 0) {
            emailFilter = new CompareFilterCriteria(
                    new FieldKey("email"), email.getText(),
                    false, true, true);

View Full Code Here

Examples of com.sun.data.provider.FilterCriteria

    
    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();
        
        int idx=0;
        FilterCriteria type = null;
        FilterCriteria firstName = null;
        FilterCriteria firstNameMax = null;
        FilterCriteria email = null;
        FilterCriteria emailMax = null;
        
        if (typeFilter.getSelected() != null &&
                ! typeFilter.getSelected().equals("")) {
            type = new CompareFilterCriteria(
                    new FieldKey("typeVolunteer"), typeFilter.getSelected());

View Full Code Here

Examples of com.sun.data.provider.FilterCriteria


    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();        
        int idx=0;
        
        FilterCriteria nameFilter = null;
        FilterCriteria nameMaxFilter = null;
        if (name.getText() != null &&
                ((String)name.getText()).length() > 0) {
            nameFilter = new CompareFilterCriteria(
                    new FieldKey("organisationName"), name.getText(),
                    false, true, true);
            idx++;
            nameMaxFilter = new CompareFilterCriteria(
                    new FieldKey("organisationName"), name.getText()+"z",
                    true, false, false);
            idx++;
        }
        
        FilterCriteria partnershipFilter = null;
        if (partnership.getValue() != null &&
                ((String)partnership.getValue()).length() > 0) {
            partnershipFilter = new CompareFilterCriteria(
                    new FieldKey("typeOfPartnership"), partnership.getValue());
            idx++;
        }
        
        FilterCriteria emailFilter = null;
        FilterCriteria emailMaxFilter = null;
        if (email.getText() != null &&
                ((String)email.getText()).length() > 0) {
            emailFilter = new CompareFilterCriteria(
                    new FieldKey("email"), email.getText(),
                    false, true, true);

View Full Code Here

Examples of com.sun.data.provider.FilterCriteria

    
    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();
        
        int idx=0;
        FilterCriteria firstName = null;
        FilterCriteria firstNameMax = null;
        if (firstNameFilter.getText() != null &&
                ((String)firstNameFilter.getText()).length() > 0) {
            firstName = new CompareFilterCriteria(
                    new FieldKey("firstName"), firstNameFilter.getText(),
                    false, true, true);
            idx++;
            firstNameMax = new CompareFilterCriteria(
                    new FieldKey("firstName"), firstNameFilter.getText()+"z",
                    true, false, false);
            idx++;
        }
        
        FilterCriteria lastName = null;
        FilterCriteria lastNameMax = null;
        if (lastNameFilter.getText() != null &&
                ((String)lastNameFilter.getText()).length() > 0) {
            lastName = new CompareFilterCriteria(
                    new FieldKey("lastName"), lastNameFilter.getText(),
                    false, true, true);
            idx++;
            lastNameMax = new CompareFilterCriteria(
                    new FieldKey("lastName"), lastNameFilter.getText()+"z",
                    true, false, false);
            idx++;
        }


        FilterCriteria email = null;
        FilterCriteria emailMax = null;
        if (emailFilter.getText() != null &&
                ((String)emailFilter.getText()).length() > 0) {
            email = new CompareFilterCriteria(
                    new FieldKey("email"), emailFilter.getText(),
                    false, true, true);

View Full Code Here

Examples of com.sun.data.provider.FilterCriteria

    
    public String buttonFilter_action() {
        tableRowGroup1.clearFilter();
        
        int idx=0;
        FilterCriteria type = null;
        FilterCriteria firstName = null;
        FilterCriteria firstNameMax = null;
        FilterCriteria email = null;
        FilterCriteria emailMax = null;
        
        if (typeFilter.getSelected() != null &&
                ! typeFilter.getSelected().equals("")) {
            type = new CompareFilterCriteria(
                    new FieldKey("typeVolunteer"), typeFilter.getSelected());

View Full Code Here

Examples of org.openhab.core.persistence.FilterCriteria

          if(hasStrategy(serviceName, config, GlobalStrategies.RESTORE)) {
            if(appliesToItem(config, item)) {
              PersistenceService service = persistenceServices.get(serviceName);
              if(service instanceof QueryablePersistenceService) {
                QueryablePersistenceService queryService = (QueryablePersistenceService) service;
                FilterCriteria filter = new FilterCriteria().setItemName(item.getName()).setPageSize(1);
                Iterable<HistoricItem> result = queryService.query(filter);
                Iterator<HistoricItem> it = result.iterator();
                if(it.hasNext()) {
                  HistoricItem historicItem = it.next();
                  GenericItem genericItem = (GenericItem) item;

View Full Code Here

Examples of org.openhab.core.persistence.FilterCriteria

   */
  static public HistoricItem historicState(Item item, AbstractInstant timestamp, String serviceName) {
    PersistenceService service = services.get(serviceName);
    if (service instanceof QueryablePersistenceService) {
      QueryablePersistenceService qService = (QueryablePersistenceService) service;
      FilterCriteria filter = new FilterCriteria();
      filter.setEndDate(timestamp.toDate());
      filter.setItemName(item.getName());
      filter.setPageSize(1);
      filter.setOrdering(Ordering.DESCENDING);
      Iterable<HistoricItem> result = qService.query(filter);
      if(result.iterator().hasNext()) {
        return result.iterator().next();
      } else {
        return null;

View Full Code Here

Examples of org.openhab.core.persistence.FilterCriteria

   */
  static public Date lastUpdate(Item item, String serviceName) {
    PersistenceService service = services.get(serviceName);
    if (service instanceof QueryablePersistenceService) {
      QueryablePersistenceService qService = (QueryablePersistenceService) service;
      FilterCriteria filter = new FilterCriteria();
      filter.setItemName(item.getName());
      filter.setOrdering(Ordering.DESCENDING);
      filter.setPageSize(1);
      Iterable<HistoricItem> result = qService.query(filter);
      if (result.iterator().hasNext()) {
        return result.iterator().next().getTimestamp();
      } else {
        return null;

View Full Code Here

Examples of org.openhab.core.persistence.FilterCriteria

   */
  static public HistoricItem previousState(Item item, boolean skipEqual, String serviceName) {
    PersistenceService service = services.get(serviceName);
    if (service instanceof QueryablePersistenceService) {
      QueryablePersistenceService qService = (QueryablePersistenceService) service;
      FilterCriteria filter = new FilterCriteria();
      filter.setItemName(item.getName());
      filter.setOrdering(Ordering.DESCENDING);


      filter.setPageSize(skipEqual ? 1000 : 1);
      int startPage = 0;
      filter.setPageNumber(startPage);


      Iterable<HistoricItem> items = qService.query(filter);
      while (items != null) {
        Iterator<HistoricItem> itemIterator = items.iterator();
        int itemCount = 0;
        while (itemIterator.hasNext()) {
          HistoricItem historicItem = itemIterator.next(); 
          itemCount++;
          if (!skipEqual || (skipEqual && !historicItem.getState().equals(item.getState()))) {
            return historicItem;
          }
        }
        if (itemCount == filter.getPageSize()) {
          filter.setPageNumber(++startPage);
          items = qService.query(filter);
        }
        else {
          items = null;
        }

View Full Code Here

0 1

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.