Adding Environment Tables

Owned by Omry Koschitzky
Last updated: Jan 29, 2019
2 min read

In the XpoLog Environment Settings page, you can define tables with variables that can be used throughout the XpoLog system. You can refer to this environment table in any field by enclosing it in brace brackets and preceding it witha $ sign, as follows: ${table name:value:key:key name}.

The advantage of using environment tables is that when the value of the variable changes, you only have to change it in the Environment Settings page, instead of every place that it appears in the XpoLog system. For example, you can add an environment table that contains the path to a logs folder, so that for every log that you add, you only need to put the environment variable’s name in the Path field, and not the full path. This way, if the path to the log folder changes, you only need to edit the environment variable’s value in one place - on the XpoLog Environment Settings page, thus ensuring that all the logs remain functional.

For example, if the logs are located under the directory "/opt/logs/",  you can save an environment variable for that location using the name logs.home.
When you add logs to XpoLog, you can type ${logs.home} in the log path, instead of the actual path.
If the logs directory is transferred elsewhere, you can simply update the environment variable with the new path. All the logs which use ${logs.home} will automatically have the updated value.

Another example, if you have reports that should be generated based on 2 shifts (day shift and night shift), you can save an environment table called “Shifts” in which you will have 2 keys, 1of2 with the value 8-20 and 2of2 with the value 20-8
When you run searches in the XpoLog Search Engine, you can type ${shifts:time:key:1of2} or ${shifts:time:key:2of2} in the search query, instead of the actual time value.
If the value of the shifts is changed, you can simply update the environment table with the new time value. All the queries which use ${shifts:time:key:1of2} or ${shifts:time:key:2of2} will automatically use the updated value.

To add an environment table: 

  1. In XpoLog Manager, on the left navigation panel select the Settings > Environment Tables.
    The XpoLog environment settings page opens.

  2. Click new environment table.

  3. In the name and value fields that appear, type the name of the environment table and its value, and then click save.