Trigger Expressions in the DB -- Where?

[wstiern]

Hi,

We want to make bulk changes to our trigger expressions. In the triggers table, the values in the expressions column look like:

{93423}>30
0
{19232}<200MB

And so on. Where are the values for these IDs stored?

Thanks.

[jamesNJ]

I don't know if this helps with your bulk update ....

I went looking through the database and it seems like the "functions" table is where to look.

You have already found the "triggers" table which holds the configured triggers, descriptions, etc.

The "item" table contains the individual items.

The "functions" table seems to glue these together with the function type and value to check against.

[wstiern]

The "functions" table seems to glue these together with the function type and value to check against.

Thanks for your comment. This is, for lack of a better term, a convoluted nightmare. I guess I'll just have to sink the time into clicking around in the interface for an afternoon.