Azure ServiceBus主题订阅上的SqlFilter不过滤 [英] SqlFilter on Azure ServiceBus Topic subscription not filtering

问题描述

我有一个WinRT应用程序，正在使用Windows 8的Windows Azure工具包.我有一个设置，希望客户订阅时忽略发给ServiceBus主题的消息，如果它们是原始发件人，或者该消息早于其订阅开始时.

I’ve got a WinRT app that I’m using the Windows Azure Toolkit for Windows 8 with. I’ve got a setup where I’d like clients subscribed to ignore messages posted to a ServiceBus Topic if they’re the originator or if the message is older than when their subscription started.

在我的BrokeredMessage的属性中，我添加了2个项目来涵盖这些情况:

In the Properties of my BrokeredMessage, I’ve added 2 items to cover these scenarios:

message.Properties["Timestamp"] = DateTime.UtcNow.ToFileTime();
message.Properties["OriginatorId"] = clientId.ToString();

clientId是一个Guid.

clientId is a Guid.

订户方看起来像这样:

// ti is a class that contains a Topic, Subscription and a bool as a cancel flag.

string FilterName = "NotMineNewOnly";

// Find or create the topic.
if (await Topic.ExistsAsync(DocumentId.ToString(), TokenProvider))
{
    ti.Topic = await Topic.GetAsync(DocumentId.ToString(), TokenProvider);
}
else
{
    ti.Topic = await Topic.CreateAsync(DocumentId.ToString(), TokenProvider);
}

// Find or create this client's subscription to the board.
if (await ti.Topic.Subscriptions.ExistsAsync(ClientSettings.Id.ToString()))
{
    ti.Subscription = await ti.Topic.Subscriptions.GetAsync(ClientSettings.Id.ToString());
}
else
{
    ti.Subscription = await ti.Topic.Subscriptions.AddAsync(ClientSettings.Id.ToString());
}

// Find or create the subscription filter.
if (!await ti.Subscription.Rules.ExistsAsync(FilterName))
{
    // Want to ignore messages generated by this client and ignore any that are older than Timestamp.
    await ti.Subscription.Rules.AddAsync(FilterName, sqlFilterExpression: string.Format("(OriginatorId != '{0}') AND (Timestamp > {1})", ClientSettings.Id, DateTime.UtcNow.ToFileTime()));
}

ti.CancelFlag = false;

Topics[boardId] = ti;

while (!ti.CancelFlag)
{
    BrokeredMessage message = await ti.Subscription.ReceiveAndDeleteAsync(TimeSpan.FromSeconds(30));

    if (!ti.CancelFlag && message != null)
    {
        // Everything gets here!  :(
    }

我把所有东西都找回来了-所以我不确定自己做错了什么.解决订阅过滤器问题的最简单方法是什么?

I get back everything – so I’m not sure what I’m doing wrong. What’s the easiest way to troubleshoot problems with subscription filters?

推荐答案

创建订阅时，默认情况下会获得"MatchAll"过滤器.在上面的代码中，您只是添加了过滤器，因此除了"MatchAll"过滤器之外，还应用了该过滤器，因此可以接收所有消息.创建订阅后，只需删除$ Default过滤器即可解决该问题.

When you create a Subscription then by default you get a "MatchAll" filter. In the code above you are just adding your filter so it is applied in addition to the "MatchAll" filter and thus all messages are recieved. Just delete the $Default filter once the Subscription is created and that should resolve the issue.

这篇关于Azure ServiceBus主题订阅上的SqlFilter不过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！