smart folder dynamic date

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
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

Highlighted
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!