Store additional information/tags in .LYRX layer file properties

Bud

I have multiple .LYRX layer files (created from Oracle EGDB query layers) that are stored in a network folder.

I want to store information in each file such as:

1. DESCRIPTION: Check for out-of-date construction projects (STATUS=FORECAST, but DATE is in the past).
2. MESSAGE: There are rows in the "Check for out-of-date construction projects" query. Please investigate.
3. DISTRIBUTION_LIST: jdoe@domain.com, jsmith@domain.com, jbrown@domain.com
4. EMAIL_SCHEDULE: Weekly
5. COMMENTS: TBD

Use Case:

I want to build a mechanism that sends scheduled emailed notifications/reports. For example, a Python script on a server that loops through layer files in the network folder. If the layer file's definition query returns >0 rows, then email the list of recipients via SMTP, using the specified schedule.

In other words, I need to store DESCRIPTION, MESSAGE, DISTRIBUTION_LIST, EMAIL_SCHEDULE , AND COMMENTS information somewhere. While I could store that information in a separate table (Excel, CSV, etc.), I'd like to have the option of storing information like that in the layer file if needed.

 

Currently, I don't think there's a way to store extra information in layer files.

Could that functionality be added? Possibly in the General tab?

Thanks.

Bud

Note:

I'm aware that Notebook Server might be an option for this kind of thing.

Unfortunately, my organization isn't interested in getting Notebook Server; I asked and they declined. And even if they were interested, they wouldn't let non-IT users like me manage my own automations/reports -- so that's not a viable option for me. I want to manage my own server-based automations, hence why I want store layer files in a folder that I can manage myself, as needed.