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
