smart folder dynamic date

cancel
Showing results for 
Search instead for 
Did you mean: 
rain
Member II

smart folder dynamic date

Jump to solution

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 Solution

Accepted Solutions
afaust
Master

Re: smart folder dynamic date

Jump to 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.

View solution in original post

2 Replies
afaust
Master

Re: smart folder dynamic date

Jump to 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
Member II

Re: smart folder dynamic date

Jump to solution

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