Add uploaded date as metadata

[mirisbowring]

Besides the document and due date, also saving the uploaded on date would be great.

I could for example order the documents by this uploaded date to check what was uploaded in the last 5 days e.x.

[eikek]

The uploaded date is used if not overwritten by the item date. The data already exists on the item. I think I can make it available in the search query. Then you can explicitly use this date. If you leave the item date empty, then the created date is used (which is the time when the database entry was created).

[mirisbowring]

So, are those two dates separate fields in the Database?

For me, this would be important.
If you for example upload a document and a date is recognized. The recognized date would be the one for the document. But if there is no "uploaded Date" as separate field, i will not be able to sort by uploaded -> regardless of the origin date.

...	Filename	Created	Uploaded
...	Document For M...	13.09.2019	09.07.2021
...	Invoice for the n...	05.07.2021	05.07.2021
...	Notice for you Ac...	04.08.2018	05.07.2021

In this Table I ordered the results by Upload date. Sometimes one finds an older documents and uploads this (in this case 2 years later).

[eikek]

Yes, these are different columns. One is the itemDate which is a user defined date. This is the one you can set in the UI to whatever you want. It can be empty/null. Then there is a createdDate which is read-only and set to the time when the record is created. If the itemDate is null, then the createdDateis used in queries instead. Currently, the createdDate is not accessible in a query explicitly, but this should be easy to add. Then you could search by created>2020-01 for example, regardless of the value in itemDate. Ordering is not yet implemented, sadly. This needs to come separatly. You can also add more dates via custom fields and search by them the same way.

[mirisbowring]

Would it be possible to make this date "available" separatly and for the "custom" Carditem box?

[eikek]

I'm sorry I think I don't understand - which carditem box do you mean? My idea currently is to not have it in the ui but usable in the query as a first shot

[eikek]

I added the created date to the query. For example, to find items added in the last 5 days you could write:

created>today;-5d

[eikek]

I'm not sure if that is what you intended :-) Ordering results should be a different issue. You can see the created date in the item detail page and now you can use it in a query. Therefore I'm closing this now; feel free to open issues for things you find missing.