## Overview This is an object to specifying a "[View](/en/manual/table-management-view)" in a "[Server Script](/en/manual/table-management-server-script)". It is possible to " [Filter](/en/manual/table-management-filter)" and "[Sort](/en/manual/table-record-sort)" records. ## Limitations 1. Only "View Processing Time" conditions can be used. ## Properties |No|Name|Get|Set|Type|Description| |:----|:----|:----|:----|:----|:----| |1|[Id](/manual/server-script-view-id)|Yes|No|int|Retrieve the current "[View](/en/manual/table-management-view)"| |2|[AlwaysGetColumns](/manual/server-script-view-always-get-columns)|Yes|Yes|Dictionary<string, string>|Specify to load "[Column](/en/manual/table-management-column)" not on the screen into the "model object"| |3|[OnSelectingWhere](/manual/server-script-view-on-selecting-where)|Yes|Yes|string|Specify "[OnSelectingWhere](/en/manual/faq-extended-sql-selecting-where)" in "「Extended SQL」" dynamically| |4|[Filters](/manual/server-script-view-filters)|Yes|Yes|Dictionary<string, string>|Specify "[Filter](/en/manual/table-management-filter)"| |5|[FilterNegative](/manual/server-script-view-filter-negative)|Yes|Yes|Dictionary<string, bool>|Specify "[Negative](/en/manual/table-record-negative-search)"| |6|[SearchTypes](/manual/server-script-view-search-types)|Yes|Yes|Dictionary<string, string>|Specify "Search Method"| |7|[Sorters](/manual/server-script-view-sorters)|Yes|Yes|Dictionary<string, string>|Specify "[Sort](/en/manual/table-record-sort)"| |8|[FiltersCleared](/manual/server-script-view-filters-cleared)|Yes|No|bool|True if view.ClearFilters() called| ## Methods |No|Name|Description| |:----|:----|:----| |1|[ClearFilters](/manual/server-script-view-clear-filters)|Clear the set filter conditions.| ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-record-negative-search">Table Function: Search for Negated Record (Filter)</a><span>10.07.2024 up</span></li> <li><a href="/en/manual/table-record-sort">Table Function: Sort Records (Sort)</a><span>10.07.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-column">Manage Table: Column</a><span>10.07.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-choice-json">Manage Table: Editor: Column Advanced Settings: Option List: Filter, Sort, Display Format</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-filter">Manage Table: Filter</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-view">Manage Table: View</a><span>10.03.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-server-script">Table Management: Server Script</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/server-script-view-add-column-placeholder">Developer Function: Server Script: view.AddColumnPlaceholder</a><span>10.04.2024 up</span></li> <li><a href="/en/manual/server-script-view-always-get-columns">Developer Function: Server Script: view.AlwaysGetColumns</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-clear-filters">Developer Function: Server Script: view.ClearFilters</a><span>10.04.2024 up</span></li> <li><a href="/en/manual/server-script-view-filters">Developer Function: Server Script: view.Filters</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-filters-cleared">Developer Function: Server Script: view.FiltersCleared</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-id">Developer Function: Server Script: view.Id</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-search-types">Developer Function: Server Script: view.SearchTypes</a><span>10.04.2024 up</span></li> <li><a href="/en/manual/server-script-view-sorters">Developer Function: Server Script: view.Sorters</a><span>12.27.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/api-view">Developer Function: JSON Data Layout: View</a><span>01.06.2025 up</span></li></ul></article> <ul><li><a href="/en/manual/faq-extended-sql-selecting-where">FAQ: How can I sort the records displayed by department?</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />