Difference between revisions of "SET FILTER"
Yvonne.milne (Talk | contribs) |
|||
(3 intermediate revisions by the same user 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 | + | [[FILTER()]], [[SET KEY]], [[SET RELATION]] |
− | + | ||
==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. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
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 07:08, 6 February 2017
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
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.
Example
use patrons set filter to event = "BALLET" and date < date() browse