smart folder dynamic date

[rain]

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!

[afaust · Accepted solution]

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.

[rain]

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