Muhammad Imran Tariq
Muhammad Imran Tariq

Reputation: 23352

JMS message selector wildcard

This link says that message selector can be written as NewsType = ’Sports’ OR NewsType = ’Opinion’

Can I use message selector for any NewsType value like

NewsType = *

Upvotes: 2

Views: 1868

Answers (2)

Anders R. Bystrup
Anders R. Bystrup

Reputation: 16060

No you can't. As the link says: The syntax .. is based on .. the SQL92 conditional expression syntax, so you would have to use

NewsType LIKE '%'

although I don't quite see why you would need a selector for that?

Cheers,

Upvotes: 4

Muhammad Imran Tariq
Muhammad Imran Tariq

Reputation: 23352

As the syntax of the expression is based on a subset of the SQL92 conditional expression syntax. It can done by using.

NewsType LIKE  '%'

Ref

Upvotes: 4

Related Questions