Filter Expressions

Apache ActiveMQ Artemis provides a powerful filter language based on a subset of the SQL 92 expression syntax.

It is the same as the syntax used for JMS selectors, but the predefined identifiers are different. For documentation on JMS selector syntax please the JMS javadoc for javax.jms.Message.

Filter expressions are used in several places in Apache ActiveMQ Artemis

• Predefined Queues. When pre-defining a queue, in broker.xml in either the core or jms configuration a filter expression can be defined for a queue. Only messages that match the filter expression will enter the queue.

• Core bridges can be defined with an optional filter expression, only matching messages will be bridged (see Core Bridges).

• Diverts can be defined with an optional filter expression, only matching messages will be diverted (see Diverts).

• Filter are also used programmatically when creating consumers, queues and in several places as described in management.

There are some differences between JMS selector expressions and Apache ActiveMQ Artemis core filter expressions. Whereas JMS selector expressions operate on a JMS message, Apache ActiveMQ Artemis core filter expressions operate on a core message.

The following identifiers can be used in a core filter expressions to refer to attributes of the core message in an expression:

• AMQPriority. To refer to the priority of a message. Message priorities are integers with valid values from 0 - 9. 0 is the lowest priority and 9 is the highest. E.g. AMQPriority = 3 AND animal = 'aardvark'

• AMQExpiration. To refer to the expiration time of a message. The value is a long integer.

• AMQDurable. To refer to whether a message is durable or not. The value is a string with valid values: DURABLE or NON_DURABLE.

• AMQTimestamp. The timestamp of when the message was created. The value is a long integer.

• AMQSize. The size of a message in bytes. The value is an integer.

Any other identifiers used in core filter expressions will be assumed to be properties of the message.

The JMS spec states that a String property should not get converted to a numeric when used in a selector. So for example, if a message has the age property set to String 21 then the following selector should not match it: age > 18. Since Apache ActiveMQ Artemis supports STOMP clients which can only send messages with string properties, that restriction is a bit limiting. Therefore, if you want your filter expressions to auto-convert String properties the the appropriate number type, just prefix it with convert_string_expressions:. If you changed the filter expression in the previous example to be convert_string_expressions:age > 18, then it would match the aforementioned message.

The JMS spec also states that property identifiers (and therefore the identifiers which are valid for use in a filter expression) are an, "unlimited-length sequence of letters and digits, the first of which must be a letter. A letter is any character for which the method Character.isJavaLetter returns true. This includes _ and $. A letter or digit is any character for which the method Character.isJavaLetterOrDigit returns true." This constraint means that hyphens (i.e. -) cannot be used. However, this constraint can be overcome by using the hyphenated_props: prefix. For example, if a message had the foo-bar property set to 0 then the filter expression hyphenated_props:foo-bar = 0 would match it.