Photo Gallery Last Updated Datetime

I have a list that shows users who have a photo gallery.

They need to opt in using a single select box, and when they do, they see the gallery tab and can upload photos.

I created the select box so I could 1) create the list of users who opt into the gallery and 2) have a link to their gallery in the forum side profile.

In the list I include a link to the gallery (Custom HTML Field), the user's name and I want to include the last time they uploaded a album.

I'm drawing a blank on how to accomplish this.

Basically I need to pull the last date from the last image or album they uploaded.

Solutions?

Thanks in advance,
Melvins138

You'd need to query for that using CB Query Field. Media is stored in the _comprofiler_plugin_gallery_item table. Albums are stored in _comprofiler_plugin_gallery_folders. Both tables provide datetime of when the media was created so you can use that to query for the most recent media entry and return the date as a result. Example as follows.


That'd return the date of the most recently uploaded media from a user. It does not have asset specified so it'll check from every gallery. You'll need to specify asset in the WHERE statement if you need it to be more specific. You can format the date using SQL functions as needed as it won't be formatted like regular date fields on output (will be SQL 0000-00-00 00:00:00 format).