NetQuarry Core Help

Namespaces

NetQuarry.Data

AggregateDisplay Enumeration

AggregateQueryExprFlags Enumeration

AggregateType Enumeration

BeforeRequeryArgs Class

BeforeRequeryHints Enumeration

BuildFilterArgs Class

ButtonScriptAddOptions Enumeration

ButtonType Enumeration

CacheDataAttrs Enumeration

CaptionFlags Enumeration

CascadedTextOptions Enumeration

CellButtonAttrs Enumeration

CellCheckBoxAttrs Enumeration

CellChooserAttrs Enumeration

CellComboBoxAttrs Enumeration

CellCurrencyAttrs Enumeration

CellDatePickerAttrs Enumeration

CellDateTimePickerAttrs Enumeration

CellEmailAddrAttrs Enumeration

CellFilePathAttrs Enumeration

CellFileUploaderAttrs Enumeration

CellFindAttrs Enumeration

CellGroupBoxAttrs Enumeration

CellHtmlAttrs Enumeration

CellIconAttrs Enumeration

CellLabelAttrs Enumeration

CellLinkAttrs Enumeration

CellListBoxAttrs Enumeration

CellMapperSummaryAttrs Enumeration

CellMultiSelectAttrs Enumeration

CellPasswordAttrs Enumeration

CellPictureAttrs Enumeration

CellRadioButtonsAttrs Enumeration

CellRatingIconAttrs Enumeration

CellSecureTextAttrs Enumeration

CellSignatureAttrs Enumeration

CellTextBoxAttrs Enumeration

CellTextWithWidgetAttrs Enumeration

CellTimeDurationAttrs Enumeration

CellTimePickerAttrs Enumeration

CellTreeAttrs Enumeration

CellTypes Enumeration

CellUrlAttrs Enumeration

CellWebSiteAttrs Enumeration

CheckList Class

Chooser Class

CommandEventArgs Class

CommandEventHandler Delegate

CommandFindType Enumeration

ControlBindingFlags Enumeration

ControlCreationFlags Enumeration

ControlValueGetFlags Enumeration

ControlValueSetFlags Enumeration

ConversionScriptOptions Enumeration

ConvertValOpts Enumeration

CreateControlArgs Class

CSV Class

DataExportHelper Class

DataExportMapperHelper Class

DatasheetLayoutAttrs Enumeration

DatasheetNavAttrs Enumeration

DatasheetPagingStyle Enumeration

DataTableRetrievalFlags Enumeration

DispTextFlags Enumeration

DuplicateRecordException Class

EditableFieldReplacementOptions Enumeration

ExecSQLArgs Class

ExecSQLArgs.ExecuteStatementType Enumeration

ExpandTemplateFlags Enumeration

ExpressionParser Class

ExpressionResolutionFlags Enumeration

Field Class

FieldAnomaly Enumeration

FieldAnomalyArgs Class

FieldAttrs Enumeration

FieldBehaviorOptions Enumeration

FieldButtonClickArgs Class

FieldCapabilities Enumeration

FieldConfirmArgs Class

FieldDeleteBehavior Enumeration

FieldDiffOptions Enumeration

FieldDisplayFormat Enumeration

FieldExecCmds Enumeration

FieldExportAttrs Enumeration

FieldExpressionAttrs Enumeration

FieldFilterFlags Enumeration

FieldFilterOptions Enumeration

FieldFindType Enumeration

FieldFormatFlags Enumeration

FieldGroupingAttrs Enumeration

FieldImportAttrs Enumeration

FieldInterfaceExtensions Class

FieldKernel Class

FieldKernel.FilterDesc Class

FieldKernel.NavInfo Class

FieldListOptions Enumeration

FieldNotFound Class

FieldPositionOptions Enumeration

FieldRawStringFlags Enumeration

FieldRefExprException Class

Fields Class

Fields.FieldNotFoundEvent Delegate

FieldSecurityAttrs Enumeration

FieldsMap Class

FieldSubsetType Enumeration

FieldTableAttrs Enumeration

FieldValidationRule Enumeration

FileUploadSources Enumeration

FilterDescOptions Enumeration

FilterException Class

FilterFlags Enumeration

FindBehaviour Enumeration

FindFullTextSearch Enumeration

Flavors Enumeration

FlavorsMap Class

FullTextSearchAttributes Enumeration

GenSelectFlags Enumeration

GetFieldListOpts Enumeration

GetFilterFlags Enumeration

GetValFlags Enumeration

GroupingInfo Class

HoverSummaryFlags Enumeration

HTMLSummaryFlags Enumeration

IDataField Interface

IField Interface

IFieldControl Interface

IFieldWidget Interface

IListField Interface

IMapper Interface

ImmediateSave Class

InvalidFieldValue Class

InvalidMapperMovement Class

ITypedMapperExtensionMarker Interface

KeyDisplayCollectionFlags Enumeration

LabelFlags Enumeration

LabelOptions Enumeration

LinkBehaviorAttributes Enumeration

LinkForNavFlags Enumeration

MapFieldSig Class

Mapper Class

MapperAttrs Enumeration

MapperBindFlags Enumeration

MapperBuildFilterArgs Class

MapperCapabilities Enumeration

MapperCloneFlags Enumeration

MapperCommand Class

MapperCommandLocation Enumeration

MapperCommands Class

MapperDiagnosticOptions Enumeration

MapperErrorContext Class

MapperExecCmds Enumeration

MapperExecFlags Enumeration

MapperExtensionBase Class

MapperExtensionKernel Class

MapperExtensions Class

MapperFilter Class

MapperFilterAttrs Enumeration

MapperFilters Class

MapperFilterType Enumeration

MapperGroupingAttrs Enumeration

MapperKernel Class

MapperKernel.MapperProcessing Enumeration

MapperKernel.MapperState Enumeration

MapperKernel.PopulateFlags Enumeration

MapperKernel.RequeryFlags Enumeration

MapperLinkFlags Enumeration

MapperList Class

MapperLoadFlags Enumeration

MapperMode Enumeration

MapperNofications Enumeration

MapperPerformanceOpts Enumeration

MapperPurposes Class

MapperRequestAction Enumeration

MapperSaveOptions Enumeration

MapperTestOptions Enumeration

MapperTruncateBehavior Enumeration

MapperTweaks Enumeration

MapperUtils Class

MaxLengthExceededException Class

MissingMapper Class

MissingRequiredFields Class

MoveReason Enumeration

OperationType Enumeration

OptimisticLockCollision Class

OrderingList Class

PicklistFillFlags Enumeration

PicklistReplaceOptions Enumeration

QuerySqlOptions Enumeration

RelatedMapperContext Class

RequeryHints Enumeration

RollupOptions Enumeration

RowCountAlgorithm Enumeration

RowDigestFlags Enumeration

RowReorderOptions Enumeration

RowsPerPagePosition Enumeration

SavedFilterApplyOptions Enumeration

SaveFilterOptions Enumeration

SchemaInfo Class

SchemaInfoCollection Class

SetFieldListOpts Enumeration

SetValFlags Enumeration

ShadowAlgorithm Enumeration

ShadowAttrs Enumeration

ShadowFiltering Class

SignaturePad Class

SizingSchemes Enumeration

SQLValueFlags Enumeration

TableInfo Class

TableInfos Class

TabOrderAttrs Enumeration

TabOrderRestrictions Enumeration

ToolTipOptions Enumeration

TypedMapper Class

TypedMapperExtension(T) Class

UnknownCommand Class

ValueConversionFlags Enumeration

WizardSummaryFlags Enumeration

WPEnvironment Enumeration

FieldFilterOptions Enumeration

Options specifying IField filtering availability and behaviour.

Namespace: NetQuarry.Data
Assembly: EAP.Core (in EAP.Core.dll) Version: 2.0.0.0 (4.6.8.0)

Syntax

Copy

[FlagsAttribute]
public enum FieldFilterOptions

<FlagsAttribute>
Public Enumeration FieldFilterOptions

Members

Member name	Value	Description
Disabled	1	Do not allow the user to filter on this field.
PreFilter	2	This field should be used to construct a 'pre-filter' that will be provided to a stored procedure or UDF query via replacement of the [[PREFILTER]] marker.
FindLock	4	Lock this field when used as Find criteria. This option is provided primarily for internal platform use.
UseFilterDefault	8	Use the DefaultValue as the default filtering value.
TextFilterWidget	16	Use the simple text filter widget rather than other a more complex filter widget as might otherwise be used.
Required	32	Criteria must be provided for this field when filtering. This is primarily used for improved performance.
Filterable	64	This field is filterable (overrides mapper/field logic decision as to filterability of field).
DefaultContains	128	Default to 'contains' filtering instead of 'starts with' filtering.
DefaultHideInList	256	By default this field should not be shown in list views, but allow user to add/remove it from the list view. See also DefaultShowInList.
UnlimitedWidgetList	512	Do not limit the number of items in a picklist filter widget.
DefaultShowInList	1024	By default this field should be shown in list views, but allow user to add/remove it from the list view. See also DefaultHideInList.
DoNotTreatNullAsZero	2048	Do not treat null values as zero when filtering.
FullTextSearch	4096	Use full-text-search (FTS) when filtering on this field. Note that this requires the field be included in an FTS index.
IgnorePicklist	8192	Ignore any Picklist when filtering on this field. This mostly makes sense when the picklist text (DisplayText) matches its key (Value). In many cases such picklists are marked with KeySameAsText, but, for performance reasons on large lists, that attribute is not currently used as a cue to ignore the picklist when filtering.
IgnoreComplexityLimits	16384	The field should ignore any SQL complexity limitations when constructing a filter. Currently the only complexity limit in place is the maximum number of OR clauses in a single filter. The default limit if 5,000 OR's, however this can be overridden via the MaxOrClauses Filtering feature. Complexity limits are intended to prevent DBMS errors such as TooComplexForQueryPlan and TooComplexLimitReachedcaused by excessive SQL complexity which consume DBMS resources and can take minutes to occur.
AllowCrossDBQueries	32768	Allow cross-DB picklist queries when filtering or sorting by this field. Note that internally cross-DB filtering/sorting queries make use of CrossDBFromClause.
CaseSensitive	65536	This field should be filtered case-sensitively. May be combined with AccentInsensitive. This flag may be overridden programmatically by CaseSensitive as well as any -collate user filtering switch (example: -collate:CSAI for case-sensitive, accent-insensitive filtering). Note that forcing case-sensitive filtering can have a severe performance impact when filtering on large data sets.
AccentInsensitive	131072	This field should be filtered case-sensitively. May be combined with CaseSensitive. This flag may be overridden programmatically by AccentInsensitive as well as any -collate user filtering switch (example: -collate:CSAI for case-sensitive, accent-insensitive filtering). Note that forcing accent-insensitive filtering can have a severe performance impact when filtering on large data sets.

Reference

NetQuarry.Data Namespace