## 概要 [サーバスクリプト](/ja/manual/table-management-server-script)で[ビュー](/ja/manual/table-record-view)の指定を行うためのオブジェクトです。「レコード」の[フィルタ](/ja/manual/table-record-search)や[ソート](/ja/manual/table-record-sort)を行うことが可能です。 ## 制限事項 1. 「ビュー処理時」の条件のみ使用できます。 ## プロパティ |No|Name|Get|Set|Type|Description| |:----|:----|:----|:----|:----|:----| |1|[Id](/manual/server-script-view-id)|○|✕|int|現在の[ビュー](/ja/manual/table-record-view)の取得| |2|[AlwaysGetColumns](/manual/server-script-view-always-get-columns)|○|○|Dictionary<string, string>|画面上にない[項目](/ja/manual/table-management-column)を「modelオブジェクト」に読み込む指定| |3|[OnSelectingWhere](/manual/server-script-view-on-selecting-where)|○|○|string|[拡張SQL](/ja/manual/extended-sql)の[OnSelectingWhere](/ja/manual/faq-extended-sql-selecting-where)を動的に指定| |4|[Filters](/manual/server-script-view-filters)|○|○|Dictionary<string, string>|[フィルタ](/ja/manual/table-record-search)の指定| |5|[FilterNegative](/manual/server-script-view-filter-negative)|○|○|Dictionary<string, bool>|[否定](/ja/manual/table-record-negative-search)の指定| |6|[SearchTypes](/manual/server-script-view-search-types)|○|○|Dictionary<string, string>|「検索方法」の指定| |7|[Sorters](/manual/server-script-view-sorters)|○|○|Dictionary<string, string>|[ソート](/ja/manual/table-record-sort)の指定| |8|[FiltersCleared](/manual/server-script-view-filters-cleared)|○|✕|bool|view.ClearFilters()が呼び出されていればtrue| ## メソッド |No|Name|Description| |:----|:----|:----| |1|[ClearFilters](/manual/server-script-view-clear-filters)|設定されているフィルター条件をクリア。| ## 関連情報 <div id="ManualList"><ul><li><a href="/en/manual/table-record-negative-search">Table Function: Search for Negated Record (Filter)</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-search">Table Function: Search for Record (Filter)</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-record-sort">テーブル機能：レコードの並び替え（ソート）</a><span>06.07.2024 up</span></li> <li><a href="/en/manual/table-record-view">Table Function: Switch Record Views</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-column">テーブルの管理：項目</a><span>06.13.2023 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-choice-json">テーブルの管理：エディタ：項目の詳細設定：選択肢一覧：フィルタ、ソート、表示フォーマット</a><span>04.09.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-filter">テーブルの管理：フィルタ</a><span>05.12.2023 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-view">Tables Management: View</a><span>08.13.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/dev-column-name">項目名とデータベース上のカラム名の対応</a><span>03.05.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/server-script">Developer Function: Server Script</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-add-column-placeholder">開発者向け機能：サーバスクリプト：view.AddColumnPlaceholder</a><span>08.25.2023 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">開発者向け機能：サーバスクリプト：view.ClearFilters</a><span>08.25.2023 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-on-selecting-where">Developer Features: Server Script: view.OnSelectingWhere</a><span>08.14.2024 up</span></li> <li><a href="/en/manual/server-script-view-search-types">開発者向け機能：サーバスクリプト：view.SearchTypes</a><span>11.15.2023 up</span></li> <li><a href="/en/manual/server-script-view-sorters">開発者向け機能：サーバスクリプト：view.Sorters</a><span>08.25.2023 up</span></li> <li><a href="/en/manual/server-script-view-filter-negative">開発者向け機能：サーバスクリプト：view.FilterNegative</a><span>06.21.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/extended-sql">開発者向け機能：拡張機能：拡張SQL</a><span>10.01.2023 up</span></li></ul></article> <ul><li><a href="/en/manual/advanced-operations-link">応用編：リンク</a><span>08.14.2023 up</span></li> <li><a href="/en/manual/advanced-operations-view">応用編：ビュー</a><span>08.25.2023 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> <ul><li><a href="/en/manual/faq-server-script-log">FAQ: I want to output the error log of a server script</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />