Example usage for com.mongodb.client.model Filters lte

List of usage examples for com.mongodb.client.model Filters lte

Introduction

In this page you can find the example usage for com.mongodb.client.model Filters lte.

Prototype

public static <TItem> Bson lte(final String fieldName, final TItem value) 

Source Link

Document

Creates a filter that matches all documents where the value of the given field is less than or equal to the specified value.

Usage

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/*  w ww . jav  a 2  s  .  c  o m*/
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDate(String fieldnamestart, Date datestartvalue, String fieldlimitname,
        Date datelimitvalue, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));

        list = filters(filter, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDate()").log(Level.SEVERE, null, e);
        exception = new Exception("filterBetweenDate() ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname//  ww  w.  j  a va  2 s .  c  o m
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDate(String secondaryfield, String secondaryfieldvalue, String fieldnamestart,
        Date datestartvalue, String fieldlimitname, Date datelimitvalue, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue),
                Filters.gte(fieldnamestart, datestartvalue), Filters.lte(fieldlimitname, datelimitvalue));

        list = filters(filter, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDate()").log(Level.SEVERE, null, e);
        exception = new Exception("filterBetweenDate() ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/* w  w  w .  j a v  a2 s  .com*/
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDate(String secondaryfield, Integer secondaryfieldvalue, String fieldnamestart,
        Date datestartvalue, String fieldlimitname, Date datelimitvalue, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue),
                Filters.gte(fieldnamestart, datestartvalue), Filters.lte(fieldlimitname, datelimitvalue));

        list = filters(filter, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDate()").log(Level.SEVERE, null, e);
        exception = new Exception("filterBetweenDate() ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname//w ww  .j  a  v  a2 s.  co  m
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDate(Bson myfilter, String fieldnamestart, Date datestartvalue,
        String fieldlimitname, Date datelimitvalue, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(myfilter, Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));

        list = filters(filter, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDate()").log(Level.SEVERE, null, e);
        exception = new Exception("filterBetweenDate() ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname//from  w w w  .java2  s  .  co m
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDateOR(Bson myfilter, String fieldnamestart, Date datestartvalue,
        String fieldlimitname, Date datelimitvalue, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson dates = Filters.and(Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));
        Bson filter = Filters.or(myfilter, dates);

        list = filters(filter, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDate()").log(Level.SEVERE, null, e);
        exception = new Exception("filterBetweenDate() ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/* w ww  .j av a2  s.  c  o m*/
 * @param datestart
 * @param endname
 * @param datelimit
 * repository.filterBetweenDate("fechainicio",permiso.getFechainicio(),"fechafin",permiso.getFechafin());
 * @return
 */
public List<T> filterBetweenDatePagination(String fieldnamestart, Date datestartvalue, String fieldlimitname,
        Date datelimitvalue, Integer pageNumber, Integer rowsForPage, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));

        list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null,
                e);
        exception = new Exception("filterBetweenDatePagination ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/*from   ww  w . j ava  2s. c  om*/
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDatePagination(String secondaryfield, String secondaryfieldvalue,
        String fieldnamestart, Date datestartvalue, String fieldlimitname, Date datelimitvalue,
        Integer pageNumber, Integer rowsForPage, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue),
                Filters.gte(fieldnamestart, datestartvalue), Filters.lte(fieldlimitname, datelimitvalue));

        list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null,
                e);
        exception = new Exception("filterBetweenDatePagination ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname//from w  w  w  .  j  a va 2  s  . c o  m
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDatePagination(String secondaryfield, Integer secondaryfieldvalue,
        String fieldnamestart, Date datestartvalue, String fieldlimitname, Date datelimitvalue,
        Integer pageNumber, Integer rowsForPage, Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson filter = Filters.and(Filters.eq(secondaryfield, secondaryfieldvalue),
                Filters.gte(fieldnamestart, datestartvalue), Filters.lte(fieldlimitname, datelimitvalue));

        list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null,
                e);
        exception = new Exception("filterBetweenDatePagination ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/*  ww w  .ja va 2  s  .  c om*/
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDatePagination(Bson myfilter, String fieldnamestart, Date datestartvalue,
        String fieldlimitname, Date datelimitvalue, Integer pageNumber, Integer rowsForPage,
        Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }

        Bson filter = Filters.and(myfilter, Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));

        list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null,
                e);
        exception = new Exception("filterBetweenDatePagination ", e);
    }

    return list;
}

From source file:com.avbravo.ejbjmoordb.mongodb.repository.Repository.java

/**
 * Crea un filtro para filtrar entre fechas
 *
 * @param startname/*from  w  w w  . j  a va  2s .com*/
 * @param datestart
 * @param endname
 * @param datelimit
 *
 * @return
 */
public List<T> filterBetweenDatePaginationOR(Bson myfilter, String fieldnamestart, Date datestartvalue,
        String fieldlimitname, Date datelimitvalue, Integer pageNumber, Integer rowsForPage,
        Document... docSort) {
    list = new ArrayList<>();
    try {
        Document sortQuery = new Document();

        if (docSort.length != 0) {
            sortQuery = docSort[0];

        }
        Bson dates = Filters.and(Filters.gte(fieldnamestart, datestartvalue),
                Filters.lte(fieldlimitname, datelimitvalue));
        Bson filter = Filters.or(myfilter, dates);

        list = filtersPagination(filter, pageNumber, rowsForPage, sortQuery);
    } catch (Exception e) {
        Logger.getLogger(Repository.class.getName() + "filterBetweenDatePagination()").log(Level.SEVERE, null,
                e);
        exception = new Exception("filterBetweenDatePagination ", e);
    }

    return list;
}