Difference between revisions of "SYSFILTERS"
From Lianjapedia
Yvonne.milne (Talk | contribs) (Created page with "==Purpose== System table for QueryBuilder filters ==See Also== QueryBuilder, System Tables ==Description== The sysfilters table is stored...") |
Yvonne.milne (Talk | contribs) |
||
Line 31: | Line 31: | ||
[[Category:Users and Roles]] | [[Category:Users and Roles]] | ||
[[Category:Reference]] | [[Category:Reference]] | ||
+ | [[Category:System Tables]] |
Latest revision as of 09:39, 22 April 2020
Contents
Purpose
System table for QueryBuilder filters
See Also
Description
The sysfilters table is stored in the system database and contains information on QueryBuilder filters.
Column | Data Type | Width | Description |
---|---|---|---|
DATABASE | C | 80 | Filter database |
TABLE | C | 80 | Filter table |
ROLES | C | 255 | Filter read permission roles |
NAME | C | 80 | Filter name |
FILTER | M | 8 | Filter query |
Example
select * from system!sysfilters