Grooper.CMIS.InPredicate

Specifies search criteria for an individual property, using a list of allowed values. Requires that property value must equal one of the values provided in a list. The IN Predicate takes the general form PropertyName IN (Value1, Value2, Value3), where PropertyName is the Query Name of a property, and the values in the list are valid values for the property.

Values for properties of type String, DateTime, URI, or ID must be enclosed in single quotes:

WHERE FileExtension IN ('.pdf', '.docx', '.xlsx')

WHERE ReceivedDate IN ('12/01/2018', '12/02/2018', '12/03/2018', '12/04/2018')

Integer and Decimal values should be unquoted:

WHERE GLCode IN (10100, 10200, 10400)

The IN Predicate is not valid for Boolean properties.


Inherits from: Grooper.CMIS.WherePredicate

Constructors

Signature Description
New (PropDef As IPropertyDefinition, Values As List(Of String), Inverted As Boolean)
Parameters
PropDef
          Type: IPropertyDefinition
          
 
Values
          Type: List`1
          
 
Inverted
          Type: Boolean
          

Fields

Field Name Field Type Description
Inverted As System.Boolean System.Boolean
PropDef As PortCMIS.Data.IPropertyDefinition PortCMIS.Data.IPropertyDefinition
Values As System.Collections.Generic.List`1[[System.String, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]] System.Collections.Generic.List(Of T)

Properties

Property Name Property Type Description
IsEmpty System.Boolean Returns true if all properties with a ViewableAttribute are set to their default value.
IsWriteable System.Boolean Returns true if the object is writable, or false if it is not.

Methods

Method Name Description
GetInvertedValue(Value As Boolean) As Boolean Returns the inverse of the passed Boolean value, if this query element's Inverted property is True, otherwise the passed Boolean value is returned.
Parameters
Value
          Type: Boolean
          
GetProperties() As PropertyDescriptorCollection
IsPropertyEnabled(PropertyName As String) As Nullable(Of Boolean) Defines whether a property is currently enabled.
Parameters
PropertyName
          Type: String
          The name of the property to determine the enabled state for.
IsPropertyVisible(PropertyName As String) As Nullable(Of Boolean) Defines whether a property is currently visible.
Parameters
PropertyName
          Type: String
          The name of the property to determine the visible state for.
IsType(Type As Type) As Boolean Returns true if the object is of the type specified, or if it derives from the type specfied.
Parameters
Type
          Type: Type
          The type to check.
ToString() As String
ValidateProperties() As ValidationErrorList Validates the properties of the object, returning a list of validation errors.