06-05-2019 02:47 AM
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!
06-07-2019 11:23 AM
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.
06-07-2019 11:23 AM
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.
06-11-2019 05:17 AM
Thank you so much for your help! Your answer solved my problem! Thank you again!
Explore our Alfresco products with the links below. Use labels to filter content by product module.