topic Re: smart folder dynamic date in Alfresco Forum

smart folder dynamic date

rain — Wed, 05 Jun 2019 09:47:30 GMT

Hello! I am working with smart folder and hit a wall. I need a smart folder with a query to a reference_valid_to date which shows all documents that are currently valid and in the future too. Is that possible? Thanks!

Re: smart folder dynamic date

afaust — Fri, 07 Jun 2019 18:23:52 GMT

This is a repost of a post in the German section: https://community.alfresco.com/thread/241919-hallo-smart-folder-mit-dynamischer-zeitabfrage

As already answered there, you can use SOLR Date Math in Alfresco FTS query expressions used in the smart folder definition. So using a query like

TYPE:"cm:content" AND cm:to:[NOW TO NOW+1YEAR/YEAR]

will get you all documents with cm:to property values from now until e.g. the beginning of next year. Of course you can adapt this to whatever "valid to" property you are using.

Re: smart folder dynamic date

rain — Tue, 11 Jun 2019 12:17:26 GMT

Thank you so much for your help! Your answer solved my problem! Thank you again!