PFQueryFilter_File Properties |
The PFQueryFilter_File type exposes the following members.
Name | Description | |
---|---|---|
Coalesce | Gets or sets a value indicating whether the column value, if null, should be converted for this test. Ex: "SampleColumn!='Test'" becomes "COALESCE(SampleColumn, '')!='Test'" if this is enabled and the chosen coalesce value is an empty string. | |
CoalesceValue | Gets or sets a value to use as an alternative for the column value if it is null. Used only if the property Coalesce is True. Ex: "SampleColumn!='Test'" becomes "COALESCE(SampleColumn, '')!='Test'" if Coalesce is True and the chosen coalesce value is an empty string. | |
EnableFullTextSearch |
Gets or sets a value indicating whether
this filter can search in the Index database for files by their content.
This setting only applies when its equivalent on the PFSite AND on the PFFileHolder field is enabled.
Default value: True. | |
ExcerptLength |
Gets or sets the maximum length of the excerpt returned by the query if the field is also selected.
Set this value to 0 to NOT return any excerpt.
Default value: 200.
| |
FieldName |
Gets or sets the name of the target field/column.
(Inherited from PFQueryFilter.) | |
FieldValue |
Gets or sets the value used for comparisons.
(Inherited from PFQueryFilter.) | |
FilterOnGroupedValues | Gets or sets a value indicating whether the filter should apply to splitted values after group instead of filtering objects directly. This will only apply -To choice and user multi-values fields. -If the filtered field is also grouped. -If the filtered value is not null. Note : this parameter is NOT serialized because its use is very rare. | |
HasRestriction |
Gets a value indicating whether there are restrictions,
(Inherited from PFQueryFilter.)limiting the use of this filter to certain objects. | |
IgnoreAccents |
Gets or sets a value indicating whether this filter should ignore accents or not.
(Inherited from PFQueryFilter.)Note : this only applies when the database is currently NOT ignoring accents by default. Attention, this can greatly degrade performances! | |
Operator |
Gets or sets the filter's operator.
(Inherited from PFQueryFilter.) | |
RestrictedToParents |
Gets or sets a list of parents' GUIDs.
(Inherited from PFQueryFilter.)If not empty, the filter will be applied to a subset of objects, depending on their parent. | |
UnknownValue |
Gets or sets a value indicating whether the filter value is already known.
(Inherited from PFQueryFilter.)This is typically used (= set to true) when a query is created to be stored and not executed immediately, e.g. for stored procedures. |