status = getStringField(147);
var regexp = /.*\s+(\S+):(\S+)\s+(.*)/g;


match = regexp.exec(status);
if (match != null)
{
    target = match[1];
    sender = match[2];
    state = match[3];
    //print("[DEBUG] matched target = " + target + " sender = " + sender + " state = " + state);
	setStringField(56, target);
	setStringField(49, sender);
    setStringField(147, state);
}

create table session_actions(
    id					serial PRIMARY KEY,
    _SenderCompId		varchar(64) NOT NULL,
    _TargetCompId		varchar(64) NOT NULL,
    _OrigTime			varchar(21) NOT NULL,
    _SessionState		varchar(20) NOT NULL
);


CREATE OR REPLACE FUNCTION insertSessionStatus
(
    _SenderCompId		varchar(64),
    _TargetCompId		varchar(64),
    _OrigTime			varchar(21),
    _SessionState		varchar(20)
)
RETURNS void
AS $$
BEGIN
    insert into session_actions(SenderCompId, TargetCompId, OrigTime, SessionState) values ( _SenderCompId, _TargetCompId, _OrigTime, _SessionState);
END;
$$
LANGUAGE plpgsql;

<?xml version="1.0" encoding="UTF-8"?>
<!--
<!DOCTYPE FIXEdge SYSTEM "BusinessLayer.dtd">
-->
<FIXEdge>
 <BusinessLayer>

  <!-- DB Table with Session Status -->
  <History 
            Name="SessionStatus"
            StorageType="ODBC"
            TableName="FIXEdge.dbo.SessionStatus"
            ConnectionString="DSN=FIXEdgeDB;UID=user;PWD=password;"
            UseStoredProcForInsert="true"
            StoredProcName="insertSessionStatus"
            >
   <KeyField ColumnName="_SenderCompId">49</KeyField> <!-- SenderCompId -->
   <KeyField ColumnName="_TargetCompId">56</KeyField> <!-- TargetCompId -->
   <KeyField ColumnName="_OrigTime">42</KeyField> <!-- OrigTime -->
   <KeyField ColumnName="_SessionState">147</KeyField> <!-- Session's State -->
  </History>

  <!-- Save Events in 35=C messages notifing about session state to DB -->
  <Rule>
   <Source>
    <FixSession SenderCompID=".*" TargetCompID=".*" />
   </Source>
   <Condition>
    <MatchField Field="35" Value="C"/>
    <MatchField Field="147" Value=".*:.*"/> <!-- Assume sender and target in 147 field is divided by ':'. The rest of the messages are redundant -->

    <Exclusion>
     <MatchMessage Value=".*147=.* AttemptToConnect.*"/>
    </Exclusion>
   </Condition>
   <Action>
    <Script Language="JavaScript" FileName="FIXEdge1/conf/prepareSessionState.js"/>
    <SaveToHistory Name="SessionStatus"/>
   </Action>
  </Rule> 

  <DefaultRule>
   <Action>
    <DoNothing/>
   </Action>
  </DefaultRule>

 </BusinessLayer>
</FIXEdge>