How to add SQLFilter to Azure service bus topic subscription

Question

I have a azure service bus topics subscription in azure function.

Below is the code for subscription:

Topic names: send-not

Subscription: send-idea, send-email

'send-idea' is subscribing to 'send-email' as well due to non availability of any filter. How can I add SQL Filter as below in azure function

Answer 1

Check the SQL Filter syntax

<function> :=  
      newid() |  
      property(name) | p(name)

Also Check the below docs

Subscription Rule SQL Filter Syntax.

Subscription Rule SQL Action Syntax.

Also Find the SO thread with related discussion.