cancel
Showing results for 
Search instead for 
Did you mean: 

smart folder dynamic date

rain
Champ in-the-making
Champ in-the-making

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!

1 ACCEPTED ANSWER

afaust
Legendary Innovator
Legendary Innovator

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.

View answer in original post

2 REPLIES 2

afaust
Legendary Innovator
Legendary Innovator

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
Champ in-the-making
Champ in-the-making

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