User Manual

04.10.2025

MANUAL

FAQ: I have performed a filter by selection, but records other than the selected item are displayed in the search results

## Answer In "[Manage Table](/en/manual/table-management)" - "「Filter」", set the "「Filter Search Type」" of the relevant column to "Exact Match". --- ## Overview When filtering by column options in the filter on the screen index for class columns with other tables, departments, or users set as options, records other than the selected column may be displayed in the search results. ### Example 1. Specify user master in the options for ClassA ([[Users]]) ![image](https://pleasanter.org/binaries/024dc805817b4417af2b7676d7dbfb62) 2. Register user master with the following details Register "Tenant Administrator" with ID 2 and "Koyama Keiko" with ID 12. ![image](https://pleasanter.org/binaries/c0dcb388dbe042ecb3f892a5104471f5) 3. If no filter is set, 3 records are displayed. ![image](https://pleasanter.org/binaries/9f4ddf053c8b4e13bc0f0e32ab933cff) 4. Select "Tenant Administrator" in ClassA using the filter. ![image](https://pleasanter.org/binaries/c3552d4f413441dc8837820d83e83401) 5. The search results include "Koyama Keiko" in addition to "Tenant Administrator". ![image](https://pleasanter.org/binaries/885a8c88b1d94c58a12158d1c69c467d) 6. In "[Manage Table](/en/manual/table-management)" - "「Filter」", the "「Filter Search Type」" for ClassA is set to "Partial Match". ![image](https://pleasanter.org/binaries/7c356a9bec07403891e3d9bd5aacc449) This is because when other tables, depts/dept/department, or users are set as options, the display selects by record title, depts/dept/department name, or user name, but the data is searched by record ID (depts/dept/department ID, user ID). In the above example, a record is searched for the user ID "2" of the selected "tenant administrator", but since the search type is "partial match", records with "2" in the user ID are searched for, and in addition to "tenant administrator", "Koyama Keiko" is also displayed as a search result. ### Solutions By setting the "「Filter Search Type」" of the corresponding column in "[Manage Table](/en/manual/table-management)" - "「Filter」" to "Exact Match", only the checked options will be displayed as search results. 1. Set "「Filter Search Type」" to "Exact Match" ![image](https://pleasanter.org/binaries/b56d7d9f6e5646cc8439380e5fd9d514) 1. Only checked options are displayed in search results ![image](https://pleasanter.org/binaries/25bdf873ac404e65b5dfc222c4703880) ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management">Manage Table</a><span>10.02.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />
TOP
このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.