document library block - date search not working

Permalink Browser Info Environment
There is a bug in the "search to" part of the advanced search.
In the controller function setupFolderAdvancedSearch()
This line:
$query->andWhere('fv.fvDateAdded >= :dateTo');
Should be:
$query->andWhere('fv.fvDateAdded <= :dateTo');


Status: New
jawbonelid

concrete5 Environment Information

# concrete5 Version
Core Version - 8.4.3
Version Installed - 8.4.3
Database Version - 20180716000000

# concrete5 Packages
None

# concrete5 Overrides
blocks/search/templates/litchfield.php, blocks/search/templates, blocks/search, blocks/litchfield_document_library/icon.png, blocks/litchfield_document_library/view.js, blocks/litchfield_document_library/controller.php, blocks/litchfield_document_library/add.php, blocks/litchfield_document_library/view.php, blocks/litchfield_document_library/edit.php, blocks/litchfield_document_library/db.xml, blocks/litchfield_document_library/view.css, blocks/litchfield_document_library, blocks/page_list/templates/litchfield.php, blocks/page_list/templates, blocks/page_list, themes/litchfield/page_theme.php, themes/litchfield/thumbnail.png, themes/litchfield/css/build/body.less, themes/litchfield/css/build/buttons.less, themes/litchfield/css/build/blocks/page-list-option-buttons.less, themes/litchfield/css/build/blocks/page-list-template-thumbnail-grid.less, themes/litchfield/css/build/blocks/topic-list.less, themes/litchfield/css/build/blocks/image-slider.less, themes/litchfield/css/build/blocks/feature-template-hover-description.less, themes/litchfield/css/build/blocks/page-attribute-display.less, themes/litchfield/css/build/blocks/feature.less, themes/litchfield/css/build/blocks/page-list.less, themes/litchfield/css/build/blocks/page-title-option-byline.less, themes/litchfield/css/build/blocks/testimonial.less, themes/litchfield/css/build/blocks/image.less, themes/litchfield/css/build/blocks/next-previous.less, themes/litchfield/css/build/blocks/date-navigation.less, themes/litchfield/css/build/blocks/faq.less, themes/litchfield/css/build/blocks/tags.less, themes/litchfield/css/build/blocks/page-title.less, themes/litchfield/css/build/blocks, themes/litchfield/css/build/content.less, themes/litchfield/css/build/reset.less, themes/litchfield/css/build/footer.less, themes/litchfield/css/build/header.less, themes/litchfield/css/build/breadcrumb.less, themes/litchfield/css/build/custom-design-classes/block-sidebar-padded.less, themes/litchfield/css/build/custom-design-classes/block-sidebar-wrapped.less, themes/litchfield/css/build/custom-design-classes/blog-entry-list.less, themes/litchfield/css/build/custom-design-classes/area-content-accent.less, themes/litchfield/css/build/custom-design-classes/testimonial-bio.less, themes/litchfield/css/build/custom-design-classes/recent-blog-entry.less, themes/litchfield/css/build/custom-design-classes, themes/litchfield/css/build/add-ons/calendar.less, themes/litchfield/css/build/add-ons, themes/litchfield/css/build/mobile/navigation.less, themes/litchfield/css/build/mobile, themes/litchfield/css/build/bootstrap-3.2.0/normalize.less, themes/litchfield/css/build/bootstrap-3.2.0/panels.less, themes/litchfield/css/build/bootstrap-3.2.0/tooltip.less, themes/litchfield/css/build/bootstrap-3.2.0/glyphicons.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/panels.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/buttons.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/size.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/center-block.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/grid.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/progress-bar.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/tab-focus.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/labels.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/text-emphasis.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/image.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/list-group.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/responsive-visibility.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/text-overflow.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/vendor-prefixes.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/reset-filter.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/nav-vertical-align.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/table-row.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/alerts.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/opacity.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/border-radius.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/background-variant.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/hide-text.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/forms.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/nav-divider.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/pagination.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/clearfix.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/resize.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/gradients.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins/grid-framework.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins, themes/litchfield/css/build/bootstrap-3.2.0/type.less, themes/litchfield/css/build/bootstrap-3.2.0/variables.less, themes/litchfield/css/build/bootstrap-3.2.0/print.less, themes/litchfield/css/build/bootstrap-3.2.0/buttons.less, themes/litchfield/css/build/bootstrap-3.2.0/thumbnails.less, themes/litchfield/css/build/bootstrap-3.2.0/grid.less, themes/litchfield/css/build/bootstrap-3.2.0/navs.less, themes/litchfield/css/build/bootstrap-3.2.0/component-animations.less, themes/litchfield/css/build/bootstrap-3.2.0/input-groups.less, themes/litchfield/css/build/bootstrap-3.2.0/scaffolding.less, themes/litchfield/css/build/bootstrap-3.2.0/button-groups.less, themes/litchfield/css/build/bootstrap-3.2.0/theme.less, themes/litchfield/css/build/bootstrap-3.2.0/pager.less, themes/litchfield/css/build/bootstrap-3.2.0/breadcrumbs.less, themes/litchfield/css/build/bootstrap-3.2.0/progress-bars.less, themes/litchfield/css/build/bootstrap-3.2.0/utilities.less, themes/litchfield/css/build/bootstrap-3.2.0/labels.less, themes/litchfield/css/build/bootstrap-3.2.0/tables.less, themes/litchfield/css/build/bootstrap-3.2.0/close.less, themes/litchfield/css/build/bootstrap-3.2.0/list-group.less, themes/litchfield/css/build/bootstrap-3.2.0/modals.less, themes/litchfield/css/build/bootstrap-3.2.0/popovers.less, themes/litchfield/css/build/bootstrap-3.2.0/navbar.less, themes/litchfield/css/build/bootstrap-3.2.0/jumbotron.less, themes/litchfield/css/build/bootstrap-3.2.0/bootstrap.less, themes/litchfield/css/build/bootstrap-3.2.0/wells.less, themes/litchfield/css/build/bootstrap-3.2.0/badges.less, themes/litchfield/css/build/bootstrap-3.2.0/alerts.less, themes/litchfield/css/build/bootstrap-3.2.0/mixins.less, themes/litchfield/css/build/bootstrap-3.2.0/responsive-embed.less, themes/litchfield/css/build/bootstrap-3.2.0/code.less, themes/litchfield/css/build/bootstrap-3.2.0/forms.less, themes/litchfield/css/build/bootstrap-3.2.0/media.less, themes/litchfield/css/build/bootstrap-3.2.0/pagination.less, themes/litchfield/css/build/bootstrap-3.2.0/responsive-utilities.less, themes/litchfield/css/build/bootstrap-3.2.0/carousel.less, themes/litchfield/css/build/bootstrap-3.2.0/dropdowns.less, themes/litchfield/css/build/bootstrap-3.2.0, themes/litchfield/css/build/errors.less, themes/litchfield/css/build/search.less, themes/litchfield/css/build/mixins.less, themes/litchfield/css/build/miscellaneous-styles.less, themes/litchfield/css/build/pagination.less, themes/litchfield/css/build/fonts/royal.less, themes/litchfield/css/build/fonts/blue-sky.less, themes/litchfield/css/build/fonts/night-road.less, themes/litchfield/css/build/fonts/defaults.less, themes/litchfield/css/build/fonts, themes/litchfield/css/build/captcha.less, themes/litchfield/css/build, themes/litchfield/css/modules/_variables.scss, themes/litchfield/css/modules/_fonts.scss, themes/litchfield/css/modules/_mixins.scss, themes/litchfield/css/modules, themes/litchfield/css/application.css.map, themes/litchfield/css/application.css, themes/litchfield/css/presets/royal.less, themes/litchfield/css/presets/blue-sky.less, themes/litchfield/css/presets/night-road.less, themes/litchfield/css/presets/defaults.less, themes/litchfield/css/presets, themes/litchfield/css/styles.xml, themes/litchfield/css/components/_forms.scss, themes/litchfield/css/components/_buttons.scss, themes/litchfield/css/components/_block_search_litchfield.scss, themes/litchfield/css/components/_block_litchfield_document_library.scss, themes/litchfield/css/components/_icons.scss, themes/litchfield/css/components/_block_page_list_litchfield.scss, themes/litchfield/css/components, themes/litchfield/css/main.less, themes/litchfield/css/layout/_page_type_media.scss, themes/litchfield/css/layout/_footer.scss, themes/litchfield/css/layout/_defaults.scss, themes/litchfield/css/layout/_header.scss, themes/litchfield/css/layout/_main.scss, themes/litchfield/css/layout/_page_type_home.scss, themes/litchfield/css/layout, themes/litchfield/css/application.scss, themes/litchfield/css/bootstrap-modified.css, themes/litchfield/css, themes/litchfield/page_not_found.php, themes/litchfield/images, themes/litchfield/media.php, themes/litchfield/full.php, themes/litchfield/view.php, themes/litchfield/home.php, themes/litchfield/elements/header_top.php, themes/litchfield/elements/footer.php, themes/litchfield/elements/header.php, themes/litchfield/elements/footer_bottom.php, themes/litchfield/elements, themes/litchfield/page_forbidden.php, themes/litchfield

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.7 (Ubuntu)

# Server API
apache2handler

# PHP Version
7.0.32-1+ubuntu14.04.1+deb.sury.org+1

# PHP Extensions
apache2handler, calendar, Core, ctype, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 8M
sql.safe_mode - Off
upload_max_filesize - 2M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:62.0) Gecko/20100101 Firefox/62.0