User-defined custom columns

User-defined column allow you to extract business data from your messages and display it as a new column. That column can then be used for sorting or filtering, like any other column. Custom columns make most sense when used with Queue Views because that way you can have one set of custom columns for one (or more) queues, and some other columns for some other queue(s).

Creating column

Use “Add/Remove columns...” from toolbar or from View menu. Then double click on one of items under “User-defined columns” or select and click “Add” button.

Editing column

Double click existing column.

Column source

ActiveMQ: Data is extracted from a message Body. MSMQ: In addition to Body, data can be extracted from message’s Extension or Label.

Column type

You can choose column type to be string, int, or double. It affects how that data gets sorted and filtered.

Sample text

In order to easier set up custom column, you can put sample text and QueueExplorer will immediately display extracted value. By clicking Load sample from current message, that text will be filled from current message, making it easy to test with real data.

XPath column

../_images/XPathColumn.png

Specify XPath expression which would be used to extract data. You can use Sample XML field in order to test your XPath. If anything is matched, it will be displayed in “Selected value” field.

JSON column

../_images/JSONColumn.png

Specify JSONPath expression which would be used to extract data. You can use Sample JSON field in order to test your expression. If anything is matched, it will be displayed in “Selected value” field.

JSONPath syntax

Regex column

../_images/RegexColumn.png

Specify Regex expression which would be used to extract data. You can use Sample text field in order to test your expression. If anything is matched, it will be displayed in “Selected value” field.