Can database values be utilized as smart values??

[Don Tyler]

I would like to compare date values that exist in a Confluence Database and if certain criteria are met, send an email notification via Confluence Automation that includes other database values (i.e. smart values)??

For example, I create virtual machines that contain content used for training.  These VMs have an SSL certificate expiration date and I would like to notify my team BEFORE this expiration to avoid issues.

Confluence Database Name:  My Very Cool Database

DB Field 1:  Title

DB Field 2: Some URL

DB Field 3: SSL Cert Expiration

Visual of sample "My Very Cool Database"

Title          Some URL                                               SSL Cert Expiration

Apples      https:/community.atlassian.com             08/29/2024

For my comparison I was using the following smart value for the criteria to match when 2 weeks before the SSL Cert Expiration value:

{{database.myVeryCoolDatabase.sslCertExpiration.diff(now).weeks.abs}}

For the notification I was trying different variations of this:

Value 1: {{database.myVeryCoolDatabase.Title}}

Value 2: {{ database.myVeryCoolDatabase.someURL}}

Value 3:  {{database.myVeryCoolDatabase.sslCertExpiration}}

I am unable to get the comparison to evaluate properly or include the expected values (obtained from the database record evaluated) but I am also not sure if this is even supported.

Any thoughts would be appreciated!! 

[Aron Gombas _Midori_]

You can find the complete list of smart values here: https://support.atlassian.com/cloud-automation/docs/smart-values-in-confluence-automation/

To be honest, I see _zero_ smart values for databases.

What I would eventually try is that, considering that a database is a custom content type, the general content properties may eventually work. But the doc suggests that even those work only for pages and blogs.

But, the granularity of per-cell, as you suggested, is very unlikely to be supported.

[Don Tyler]

Thanks for the reply Aron.  I also did not see anything related to databases in the smart value list which I was assuming meant it was not supported.  That being said, when I tried to use the AI to build something it recommended something similar to what I had in this post so I was hopeful.  It didn't work for me though unfortunately so thought maybe the Community could steer me down the right path, or just confirm that this was not supported at this time (but hopefully in the future!).

[Aron Gombas _Midori_]

Wow, it sounds like the AI hallucinated non-existing things. :-)