> > > PostgreSQL :: How-to Retrieve Filename in Ruleset

PostgreSQL :: How-to Retrieve Filename in Ruleset

12th August 2017

Cleo Clarify Postgre Database Log of Property Value

When a file is receive d via a filesystem monitor, users might want to populate their internal files/tables with the actual filename. Longterm EBI/Clarify users know this is not an easy task.

Below is the SQL statement that can assist users when create a SQL Action to retrieve the filename.

SELECT “VALUE” FROM “EBI”.“LOG_PROPERTY_VALUE” V WHERE (V.“NAME” = ‘filename’ or V.“NAME” = 'Filename’) AND V.“LOG_ID” = (SELECT “LOG_ID” FROM “EBI”.“RELATED_LOG” R WHERE (R.“RELATED_LOG_ID” = ${Input} AND R.“RELATED_LOG_TYPE”=50331651 AND R.“LOG_TYPE” = 50331653))

For users unsure of accessing the internal PostgreSQL tables, we discussed access to the internal PostgreSQL database tables.


By: on