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).
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.
Double click existing column.
ActiveMQ: Data is extracted from a message Body. MSMQ: In addition to Body, data can be extracted from message’s Extension or Label.
You can choose column type to be string, int, or double. It affects how that data gets sorted and filtered.
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.
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.
Default namespace in XML
If XML document has a namespace without any prefix, XPath has to use _default prefix.
For example, if XML is:
<books xmlns="http://books.com"> <book category="cooking"> <title lang="en">Everyday Italian</title> <year>2005</year> <price>30.00</price> </book> </books>
Your XPath should be:
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.
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.