Trigger to publish file asset at a time determined by metadata date field

Squiz Matrix Support
1

Problem:
File asset has a metadata field (EffectiveDate), which can be in the future. I need a trigger to publish this asset at the time that is set in the metadata date field.

My solution (which doesn’t work):
Trigger event: Asset Metadata Updated
Condition 1: Metadata date field with expired value = the metadata field value (metadata field asset selected here)
Condition 2: The asset is under a particular node in the tree.
Action: Set status to “Live”. Execution time: Determined by the metadata date field (metadata field asset selected here)

This all seems logical, but isn’t working. Assistance please!

2

Why are you trying to use metadata field to control status scheduling? Easier to use future status in details screen.

If you want to use metadata, use “Metadata Time” as the event. The rest is pretty straightforward from there (use Metadata time expired as condition).

2 Likes
3

Yea future status is probably the better way to go.

Also, if you are using the trigger, make sure your metadata date field you are checking the value on is in ISO format: Y-m-d H:i:s

4

Guys, thanks for the replies.

Yes, I know that it would be better to use future status, but there were more practical reasons why I needed to use a metadata field, including being able to search on it and sort by it etc. I’ll certainly rethink this however, and take it back to the business.

@pilvonen: metadata time is not good, because it uses cron jobs.
@Bart: I believe I’ve set the correct date format, but I’ll certainly double-check

5

Guys, metadata time event WAS the way to go. It’s working now.

Thanks

1 Like