id |
integer |
Yes |
Yes |
nextval('system_filters_id_seq'::regclass) |
Unique identifier |
window |
character varying(100) |
No |
No |
|
Spire list screen for this record |
name |
character varying(100) |
No |
No |
|
Name or description of filter as set by user |
inmenu |
boolean |
No |
No |
|
Display on main menu flag; FALSE = No TRUE = Yes |
filter_state |
json |
No |
No |
|
Filter criteria |
table_state |
json |
No |
No |
|
Column settings |
save_table |
boolean |
Yes |
No |
|
Save this settings flag; FALSE = No TRUE = Yes |
user_id |
integer |
No |
No |
|
Identifier from system_users_base.id related to this record, blank = all users |