Instruction Criteria Input - Reference


Table:Inst_Poss_Criteria
Column: IPC_Ref

The IPC_Ref column of the Iinst_Poss_Criteria table defines the technical reference location for accessing data in the Fautore application. How the value in this table field is used is dependent on the value stored to the IPC_Type column of the Inst_Poss_Criteria table. This field can be thought of as a path specifier to data referenced referenced for comparison when determining how to process a message.

Separator

In the case of the "Message" and "Application" IPC_Type value types the double colon pair (::) is used to separate the pathing references to the data.

Type - Message

When the IPC_Type is "Message" the data in IPC_Ref refers to a database table and column. In this case the path depth should never be more than two elements with a single double colon pair as a separator. The format is as follows:

{Table}::{Column}
Staging::Title
Indicates the "Title" column of the "Staging" table is being referenced.

Type - Application

When the IPC_Type is "Application" the data in IPC_Ref refers to an element of the application specific JSON bundled in the "Adjunct" column of the Staging table. The format it as follows:

{Application}::{Element}::{SubElement}::{SubElement}:etc...
SMTP::Priority::Level
Indicates the "Level" attribute of the "Priority" element of message data generated by, and specific to, the SMTP application is being referenced.

Type - Function

When the IPC_Type is "Function" the data in IPC_Ref refers to a Perl function defined in the Fautore::ActionFuncs.pm module file. The return value of these functions is compared to the value stored in the IC_Value field of the IC_Criter_Eval column for the same row of the defined criteria using the function. Value is a single element formatted as follows:

{function}()
time()
Return the current time of message processing. Useful for routing messages by time of day.