Keyword for File asset uploaded date (from the details screen) as opposed to the asset updated date

(Tim Davison) #1

Hi all

 

I'm trying to generate a list of file assets and display the date the file itself was last updated/uploaded.  Date I'm after is the date uploaded shown on the details screen, rather than the last updated date for the asset.  

 

I was using last_updated keyword in my asset list, but I ran a batch overnight setting workflows, so now every file has an updated date of today.

 

Looks like what is discussed in this topic:

http://forums.squizsuite.net/index.php?showtopic=11525&p=50308

 

So I'm assuming there is no way to access this info via keyword - please correct me if I'm wrong.

 

Does anyone know if there is another way, e.g. JSAPI?   

 

Thanks

(Bart Banda) #2

I don't think so, as it is not logged as an attribute. You could potentially create a metadata date field and have a trigger that updates it everytime the file is changed?

(Nic Hubbard) #3

I don't think so, as it is not logged as an attribute. You could potentially create a metadata date field and have a trigger that updates it everytime the file is changed?

 

Where is that info generated from then?

(Joel Porgand) #4

 

Where is that info generated from then?

 

couldn't you just use %globals_date_X% ?

(Nic Hubbard) #5

 

couldn't you just use %globals_date_X% ?

 

To get the last date a file asset was uploaded/updated? Confused. 

(Joel Porgand) #6

 

To get the last date a file asset was uploaded/updated? Confused. 

 

at the time the trigger is fired, using "replace keywords in set value"

 

however looks like they've added a "set metadata field date" action so use that one with the offsets set to 0

(Bart Banda) #7

 

Where is that info generated from then?

 

It might be reading it straight off the file on the server, but I might be wrong. If it's an attribute, we should be able to create a keyword for accessing it pretty easy, and if its not, we'd just have to add it as a new one, which probably wouldn't be hard either. 

(Tim Davison) #8

Bart, is that something we should raise/request in Squizmap?  It's something I would vote for - we would have a very definite use for it.

(Bart Banda) #9

Yea for sure, submit it in and then we can get the effort and feasibility reviewed by the devs, hopefully its a nice and easy one. 

(Brad Ingram) #10

Hi Guys, has there been any progress on this? Im having this same issue trying to show the actual date the file was last updated as opposed to showing the last time any other changes were made to the asset. Cheers.

(Harinder Singh) #11

Hi Brad,

I requested the following keyword while ago. The keyword wasn’t available so we had to pay for it as a feature request.

%asset_file_updated%
%asset_file_updated_readable%

%asset_file_updated_readable^date_format:j M Y%

I hope this is what you after.

(Brad Ingram) #12

Thanks Harinder!

Just a quick one though, will these just work automatically or will something need to be set up in our system. Also were these set up to work in a certain version? Our Intranet is sitting on an old version of Squiz but it will be upgraded to the latest version (the same as our external website) soon, just trying to work out if they’ll work on the Intranet (where i need the keywords more).

Cheers.

(Bart Banda) #13

This keyword is only available from version 5.3.4.1 and up of Squiz Matrix, I’m guessing you are on an older version than that? https://matrix.squiz.net/news/2016/matrix-5.2.11.1-and-5.3.4.1-released