Compartilhar via


NotificationComputedField.DigestGrouping Property

Gets or sets the digest grouping setting, which specifies if the field is used to determine which notifications are combined into a digest.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
Public Property DigestGrouping As Boolean
public bool DigestGrouping { get; set; }
public:
property bool DigestGrouping {
    bool get ();
    void set (bool value);
}
/** @property */
public boolean get_DigestGrouping ()

/** @property */
public void set_DigestGrouping (boolean value)
public function get DigestGrouping () : boolean

public function set DigestGrouping (value : boolean)

Property Value

true if the computed field is used to determine digest grouping; otherwise, false.

Remarks

The DigestGrouping property is optional, and the default value is false.

If you want a computed field used to determine if notifications should be grouped when using digest delivery, set DigestGrouping to true. For example, if a calendar application notifies users of future events, you can set DigestGrouping to true on a computed DaysToEvent field so that only notifications for events on the same day are grouped into a single notification.

If you are using digest delivery but you do not set DigestGrouping to true on any fields, Notification Services groups messages within a notification batch that have the same SubscriberId, DeviceName, and SubscriberLocale values.

If you add, delete, or update a DigestGrouping element, updating the application deletes and re-creates the notification class to which it corresponds. This includes dropping and re-creating the Microsoft SQL Server tables used by this notification class.

Example

The following examples show how to set the DigestGrouping property when using the default constructor:

NotificationComputedField computedPrice = 
    new NotificationComputedField();
computedPrice.Name = "FormattedPrice";
computedPrice.Parent = flightNotifications;
computedPrice.DigestGrouping = false;
computedPrice.SqlExpression = "CONVERT(NVARCHAR(10), Price, 1)";
flightNotifications.NotificationComputedFields.Add(computedPrice);
Dim computedPrice As NotificationComputedField = _
    New NotificationComputedField()
computedPrice.Name = "FormattedPrice"
computedPrice.Parent = flightNotifications
computedPrice.DigestGrouping = False
computedPrice.SqlExpression = "CONVERT(NVARCHAR(10), Price, 1)"
flightNotifications.NotificationComputedFields.Add(computedPrice)

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

NotificationComputedField Class
NotificationComputedField Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Defining the Notification Schema
DigestGrouping Element for ComputedField (ADF)