Click or drag to resize

ICursorFilterTypeF Interface

Interface for CursorFilterTypeF.

Namespace:  Vovin.CmcLibNet.Database
Assembly:  Vovin.CmcLibNet (in Vovin.CmcLibNet.dll) Version: 1.0.7729.42686
Syntax
public interface ICursorFilterTypeF : ICursorFilter

The ICursorFilterTypeF type exposes the following members.

Properties
  NameDescription
Public propertyClauseNumber
Filter clause number. Should be a number between 1 and 8.
Public propertyExcept
Specify Not-filter. Equivalent to the 'Except' chekbox in a filtyer dialog
Public propertyFieldName
Field to evaluate.
Public propertyFieldValue
Fieldvalue to evaluate. Ignored when Between qualifier is used.
Public propertyFilterBetweenEndValue
End value (inclusive) for filters with Between qualifier. Used only with Between qualifier. When this property is set, you must also set FilterStartEndValue.
Public propertyFilterBetweenStartValue
Start value (inclusive) for filters with Between qualifier. Used only with Between qualifier. When this property is set, you must also set FilterBetweenEndValue.
Public propertyFiltertypeIdentifier
String representing the filtertype identifier for use in a Commence DDE request.
Public propertyMatchCase
Case-sensitive parameter. Set to true for case-sensitive filter. Defaults to false.
Public propertyOrFilter
Specify if this filter must be treated as an Or filter. Default is false.
Public propertyQualifier
Convenience property for the qualifier for in .NET applications. This property takes precedence over QualifierString.
Public propertyQualifierString
String value specifying how to evaluate the filtervalue. Not all qualifiers can be used on all field-types. See Commence ViewFilter documentation in DDE helpfile.

If you use COM, either use this member with the strings listed below, or supply the FilterQualifier enum value to Qualifier. .NET users are strongly encouraged to use Qualifier.

List of valid qualifier strings and the fields they can be applied to.

Qualifier stringApplies to fieldtype(s)
Equal ToName, Calculation, E-mail, URL, Number, Selection, Sequence, Telephone, Text fields.
Not Equal ToName, Calculation, E-mail, URL, Number, Selection, Sequence, Telephone, Text fields.
Less ThanCalculation, Number, Sequence number fields.
Greater ThanCalculation, Number, Sequence number fields.
BetweenName, Calculation, Date, E-mail, URL, Number, Sequence number, Time fields.
TrueCheckbox fields.
FalseCheckbox fields.
CheckedCheckbox fields.
Not CheckedCheckbox fields.
YesCheckbox fields.
NoCheckbox fields.
BeforeDate, Time fields.
OnDate fields.
AtTime fields.
AfterDate, Time fields.
ContainsName, E-mail, URL, Telephone, Text fields.
Doesn't ContainName, E-mail, URL, Telephone, Text fields.
SharedN/A when used with fields.
LocalN/A when used with fields.
1Checkbox fields.
0Checkbox fields.
Public propertyShared
Filter for Local/Shared items.
Public propertySharedOptionSet
Keep track of whether the 'shared/local' option was set
Top
Methods
  NameDescription
Public methodGetViewFilterString
Returns the ViewFilter string, useful for debugging.
Public methodToString
Overload allowing custom formatting.
(Inherited from ICursorFilter.)
Top
See Also