Difference between revisions of "SET FILTER"
Yvonne.milne (Talk | contribs) m (1 revision) |
Barrymavin (Talk | contribs) (→Description) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Seclude records in a table that do not satisfy a certain condition | Seclude records in a table that do not satisfy a certain condition | ||
| − | |||
==Syntax== | ==Syntax== | ||
| Line 7: | Line 6: | ||
SET FILTER ON | OFF | (<expL>) | SET FILTER ON | OFF | (<expL>) | ||
| − | |||
==See Also== | ==See Also== | ||
| − | [[FILTER()]], [[SET RELATION]], [[SET | + | [[FILTER()]], [[SET KEY]], [[SET RELATION]], [[SET RUSHMORE]] |
| − | + | ||
==Description== | ==Description== | ||
If SET FILTER TO <condition> is specified, records that do not satisfy the specified <condition> are automatically secluded. If SET FILTER TO is specified, without a <condition>, the current filter is removed allowing all records to be accessed. The filter <condition> is specific to each workarea, and is removed when a table is closed, or the workarea is re-used. However, the FILTER condition can contain references to fields in related tables. The FILTER() function can be used to save the current filter <condition>. The SET FILTER command enables or disables the filtering process. By default, FILTER is ON. | If SET FILTER TO <condition> is specified, records that do not satisfy the specified <condition> are automatically secluded. If SET FILTER TO is specified, without a <condition>, the current filter is removed allowing all records to be accessed. The filter <condition> is specific to each workarea, and is removed when a table is closed, or the workarea is re-used. However, the FILTER condition can contain references to fields in related tables. The FILTER() function can be used to save the current filter <condition>. The SET FILTER command enables or disables the filtering process. By default, FILTER is ON. | ||
| + | If [[SET RUSHMORE]] is ON (default) then the filter is optimized, | ||
==Example== | ==Example== | ||
| Line 23: | Line 21: | ||
browse</code> | browse</code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Set_Commands|FILTER]] | [[Category:Set_Commands|FILTER]] | ||
| + | [[Category:NoSQL Commands]] | ||
Latest revision as of 22:39, 22 May 2024
Contents
Purpose
Seclude records in a table that do not satisfy a certain condition
Syntax
SET FILTER TO [<condition>]
SET FILTER ON | OFF | (<expL>)
See Also
FILTER(), SET KEY, SET RELATION, SET RUSHMORE
Description
If SET FILTER TO <condition> is specified, records that do not satisfy the specified <condition> are automatically secluded. If SET FILTER TO is specified, without a <condition>, the current filter is removed allowing all records to be accessed. The filter <condition> is specific to each workarea, and is removed when a table is closed, or the workarea is re-used. However, the FILTER condition can contain references to fields in related tables. The FILTER() function can be used to save the current filter <condition>. The SET FILTER command enables or disables the filtering process. By default, FILTER is ON.
If SET RUSHMORE is ON (default) then the filter is optimized,
Example
use patrons set filter to event = "BALLET" and date < date() browse
