SQL Filters in service bus not working

Question

I created a topic "Messages" in my service bus instance, and added a new subscription to it. I can send messages to this topic and the Azure Function v3 trigger is activated just fine. The message is received and displayed in an instant.
When I add an sql filter to filter messages for a subscription it is not working anymore.

What I did so far.
Created an sql filter in the azure portal:

sys.Label = "Test" -> Not working as no messages are received anymore, even though I verified that the Label attribute is set.    

sys.Label != "Test" Not working as no messages are received anymore, even though I verified that the Label attribute is set and not matching "Test"    

sys.To = "Test" -> Not working, no messages are received. Verified that the messages contain the To member.    

sys.Label is not Null -> This is strangely working.    

What am I doing wrong here?

Answer 1

Hi @Exitare

Welcome to Microsoft Q&A! Thanks for posting the question.

The SQL filter value should be in single quotes 'test'

Example : sys.To = 'test'

Make sure that you are defining the message system properties while sending the message to topic.

Feel free to get back to me if you need any assistance.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.