10-08-2019 01:57 AM
For my use case I need to find documents within a certain date time range. E.g. find all documents created between October 8th 0:00 and October 8th 12:00. When I use DocumentQuery.AddDateRange(fromDate, toDate) the time part is being ignored. Resulting in all documents from October 8th.
Is there a way find documents that were created within a certain time range?
10-08-2019 03:30 AM
In my experience, the date range you are referring to represents the "Document Date" value you see on the keyword panel. "Document Date" is a true date field, not a date/time field, so you can't get time-specific with a document query. The date created is a property on the document object and is called "Date Stored" which has a full date/time stamp. Assuming the "Document Date" on your documents is defaulting to the date created in OnBase, you could take the document query results you are currently getting and iterate through them. By checking the "Date Stored" property on each document, you would be able to filter the results down to the time range that you expected from your initial document query.
Cheers!
10-08-2019 03:30 AM
In my experience, the date range you are referring to represents the "Document Date" value you see on the keyword panel. "Document Date" is a true date field, not a date/time field, so you can't get time-specific with a document query. The date created is a property on the document object and is called "Date Stored" which has a full date/time stamp. Assuming the "Document Date" on your documents is defaulting to the date created in OnBase, you could take the document query results you are currently getting and iterate through them. By checking the "Date Stored" property on each document, you would be able to filter the results down to the time range that you expected from your initial document query.
Cheers!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.