User Manual

08.14.2024

MANUAL

FAQ: I want to display only specific users in the selection list

## Answer Use the "[Filter](/en/manual/table-record-search)" function of the options list in combination with "ColumnFilterSearchTypes" of "[View](/en/manual/table-record-view)". --- ## Overview To display users whose names start with a specified string or users whose names contain a specified string in the options, use the "[Filter](/en/manual/table-record-search)" function of the options list. ### User (no filtering) ![image](https://pleasanter.org/binaries/b5a6c390c7df49579734fb96dcf3667d) ### Example 1. Users whose names start with "Yama" Use the "[Filter](/en/manual/table-record-search)" function of the option list to narrow down the options. In this case, if you specify "ForwardMatch" for "ColumnFilterSearchTypes" of "[View](/en/manual/table-record-view)", users whose names specified in ColumnFilterHash start with "Yama" will be displayed. ##### JSON ``` [ { "TableName": "Users", "View": { "ColumnFilterHash": { "Name": "Yama" }, ColumnFilterSearchTypes:{ Title: "ForwardMatch" } } } ] ``` ### Display Results ![image](https://pleasanter.org/binaries/2d4feb2e59b5477f9a2ff054c23ff9e7) ### Example 2. Users whose names contain "Ichi" As in Example 1, use the "[Filter](/en/manual/table-record-search)" function in the list of options to narrow down the options. In this example, "PartialMatch" is specified for "ColumnFilterSearchTypes" in "[View](/en/manual/table-record-view)", so users whose names specified in ColumnFilterHash contain "Ichi" are displayed. ##### JSON ``` [ { "TableName": "Users", "View": { "ColumnFilterHash": { "Name": "Ichi" }, ColumnFilterSearchTypes:{ Title: "PartialMatch" } } } ] ``` ### Display Results ![image](https://pleasanter.org/binaries/99558fa489594fe4b59e7b75a81a514e) ## Related Information <div id="ManualList"><ul><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-view">Table Function: Switch Record Views</a><span>08.13.2024 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/api-view">開発者向け機能:JSONデータレイアウト:View</a><span>11.06.2023 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.