Option to sort by created_at date

[ellierider]

Is your feature request related to a problem? Please describe.

There is currently no way to sort redirects by the creation date. This makes it hard to audit what has recently been implemented.

Describe the solution you would like

I would like the option to sort redirects by the creation date. Just another column next to the current ones on the Redirects tab.

Describe alternatives you have considered

I could try to audit the database but this isn't feasible for end-users. I'm not sure if there would be a way to query this into a dashboard

Additional context

Screenshot https://cln.sh/FmNVyj

[tekstrand]

I'd like to follow up here and say that not just sorting, but being able to simply see the created dates/updated dates would be great. The data is already in the database! @khalwat :)

[bmorykon]

+1

I read in a related issue that what matters is the last hit, not when it was created. For our use case, sorting by created date is most helpful. I often set up short urls to external sites. Sometimes I want to tweak that redirect or quickly check if it's being used. We have so many redirects, that one I created last week might not being Dashboard, but it's still occasionally being used.

In fact, I never use the Dashboard and would remove it if I could. Both sorting by hits and "last hit" is useless, because it's full of attempted hack urls:

[khalwat]

@bmorykon in your case, I'd recommend using the excludePatterns to ignore things you don't want tracked:

Retour -> Settings

https://github.com/nystudio107/craft-retour/blob/develop/src/config.php#L63

You can have it completely ignore these "junk" URL patterns the bots are hitting, so that your Dashboard is usable again.

[bmorykon]

Awesome, thanks! I just noticed that after I submitted. There is so much junk it’s gonna take awhile to set up the regex’s to catch it all, but that’ll definitely help.

I’d still find it super helpful to sort by create date.

[flannelinc]

Commenting to show support for this request. Seems like basic functionality for a control panel interface. I have had a couple clients ask for this. Thank you in advance!