search

specify / specify7

Specify 7
https://www.specifysoftware.org/products/specify-7/
GNU General Public License v2.0
66 stars 36 forks source link

Timestamp Modified not displaying time in query #477

Open yvonneekanim opened 6 years ago

yvonneekanim commented 6 years ago

When timestamp modified is queried in 7, the query result only displays the date and not the time. It displays both date and time in 6.

benanhalt commented 5 years ago

This behavior was added in https://github.com/specify/specify7/commit/9cbddfd866726edc295eb85668e796f7ca4efe90 probably so modifications that occur on a specific date could be easily queried.

maxpatiiuk commented 1 year ago

This is part of a broader issue of specify 7 not supporting time in any shape or form - there is no way to query on time, or display time on a form

grantfitzsimmons commented 9 months ago

We have started using the labels that can be produced from within Specify for our cryptogam packets at the end of last year. While in test, this worked exceptionally well in Specify 7, but now that it is in production, we encounter some issues, and differences with Specify 6, with how timestamps and dates are handled in the Specify 7 query.

People here like to print packets in the order they have databased the specimens, so that it is easy matching up the specimen with the packet it needs to go in. So, we order the results of the label query by the TimestampCreated of the Collection Object. This works fine in Specify 6:

image

but in Specify 7 the time part is stripped off the timestamp, so specimens that have been databased on the same day will come out in pretty much random order:

image

We generally print batches of 50 to 100 packets, so, if they are not in the right order, it makes for a much more time-consuming job to match up the packets and the specimens.

Reported By: @nielsklazenga on the Speciforum

melton-jason commented 9 months ago

This is part of a broader issue of specify 7 not supporting time in any shape or form - there is no way to query on time, or display time on a form

https://github.com/specify/specify7/issues/477#issuecomment-1459188835

This behavior (specify not respecting the time information of date fields) would likely be implemented with the fix for #641. The fix for this issue specifically would involve undoing the changes from https://github.com/specify/specify7/commit/9cbddfd866726edc295eb85668e796f7ca4efe90 (see https://github.com/specify/specify7/issues/477#issuecomment-486365137) once #641 is fixed

specifysoftware commented 9 months ago

This issue has been mentioned on Specify Community Forum. There might be relevant details there:

https://discourse.specifysoftware.org/t/issues-with-dates-and-timestamps-in-specify-7-query/1538/2

emenslin commented 4 months ago

Can recreate in edge (7.9.6)