RecordRestrictionFilterExpression Field

Defines filter SQL expression for restriction as a composite format string - does not include WHERE. When escaping is needed for field names, use standard ANSI quotes.

Namespace: GSF.Data.Model
Assembly: GSF.Core (in GSF.Core.dll) Version: 2.4.181-beta

Syntax

C++

JavaScript

Copy

public readonly string FilterExpression

Public ReadOnly FilterExpression As String

public:
initonly String^ FilterExpression

val FilterExpression: string

var FilterExpression

View Source

Field Value

String

Remarks

Each indexed parameter, e.g., "{0}", in the composite format string will be converted into query parameters where each of the corresponding values in the Parameters collection will be applied as IDbDataParameter values to an executed IDbCommand query.

If needed, field names that are escaped with standard ANSI quotes in the filter expression will be updated to reflect what is defined in the user model.

Reference

RecordRestriction Class

GSF.Data.Model Namespace