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!
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.
Thank you so much for your help! Your answer solved my problem! Thank you again!
