GIS/SI Envelopes Report (II)

Problem

Sometimes users need to have a detailed report about the envelopes they have in GIS/SI, but GIS doesn’t have such functionality. For example, you want to have a list of ISA/GS envelopes with the names, Sender/ReceiverIDs but there is no built-in functionality to get it easily. So, you have to check envelopes one by one (which is not very useful).

Solution 2

There is another solution for this problem (see Solution 1 here). GIS/SI stores envelopes information in the database, and if you have access to it and know SQL, you can get all the information you need.

There are 3 tables for the Envelopes:

  1. ENVELOPE. This table contains base information about all the envelopes and their versions – name, direction, comments, sender/receiver IDs and so on.
  2. ENVELOPE_PARMS. This table contains envelope-specific information (for example, “ISA IEA” envelopes are not the same as “GS GE” or “UNB UNZ Syntax 4” ones). It’s a key-value table (columns NAME and VALUE), linked to ENVELOPE table with using of ENVELOPE_ID foreign key.
  3. ENVELOPE_VERSIONS. This table contains information about envelopes’ default versions. It’s linked to ENVELOPE table with using of ENVELOPE_ID and DEFAULT_VERSION foreign keys.

So, to get the information about default envelopes and sender/receiver IDs you need to run an SQL query like this:

SELECT e.NAME, e.SENDER_ID, e.RECEIVER_ID
FROM
  gis_admin.envelope e,
  gis_admin.envelope_versions ev
WHERE
  e.envelope_id = ev.envelope_id
  and e.envelope_version = ev.default_version
ORDER BY e.name

Gennady Kim

Advertisements

2 thoughts on “GIS/SI Envelopes Report (II)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s