rebus-org / Rebus.SqlServer

:bus: Microsoft SQL Server transport and persistence for Rebus
https://mookid.dk/category/rebus
Other
43 stars 42 forks source link

Add CreationTime timestamp #11

Closed mookid8000 closed 6 years ago

mookid8000 commented 6 years ago

because it is not possible to see the age of attachments that have not yet been read and might never be, which makes it hard to come up with a sensible way of removing these attachments.

IsaacSee commented 6 years ago

Added following pull request for this enhancement #18

mookid8000 commented 6 years ago

Will be available in version 5.0.0 (which can be tried now in 5.0.0-b1)

CzechsMix commented 4 years ago

Is this just for databus? or is there a config option needed to turn this on?

I'm using Rebus.SqlServer 5.1 and I'm not seeing the CreationTime column in any of my queue tables.

mookid8000 commented 4 years ago

That particular creation time can actually be had by parsing the headers, as it’s embedded there as rbs2-sent-time

Sendt fra min iPhone

– Mogens Heller Grabe Torsmark 4 8700 Horsens Danmark

+45 29367077 mookid8000@gmail.com

Den 13. dec. 2019 kl. 05.35 skrev Sam Ferree notifications@github.com:

 Is this just for databus? or is there a config option needed to turn this on?

I'm using Rebus.SqlServer 5.1 and I'm not seeing the CreationTime column in any of my queue tables.

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or unsubscribe.

CzechsMix commented 4 years ago

So if I wanted to do something like see all the messages sent in the last hour there's not a simple SQL Query I could execute?

If I'm not using the Defer functionality, is the 'visible' column essentially the same thing?

mookid8000 commented 4 years ago

I think it is, yeah 🙂

Sendt fra min iPhone

– Mogens Heller Grabe Torsmark 4 8700 Horsens Danmark

+45 29367077 mookid8000@gmail.com

Den 13. dec. 2019 kl. 19.17 skrev Sam Ferree notifications@github.com:

 So if I wanted to do something like see all the messages sent in the last hour there's not a simple SQL Query I could execute?

If I'm not using the Defer functionality, is the 'visible' column essentially the same thing?

— You are receiving this because you modified the open/close state. Reply to this email directly, view it on GitHub, or unsubscribe.