## Overview By operating the Negation menu in the "[Filter](/en/manual/table-record-search)" at the top of the list screen, you can search for records with negation conditions for specific items. Multiple conditions can also be combined. If "[View Save Type](/en/manual/dashboard-view)" is set to "Session" or "[User](/en/manual/table-management-choices-text-users)", the filter you set will be retained even after transitioning to other screens. The filter works in chart screens such as "[Calendar](/en/manual/table-calendar)" and "[Gantt Chart](/en/manual/table-management-gantt)" in the same way as in the list screen.  ## Supported Versions 1. Pleasanter 1.3.18.0 or later ## Limitations 1. If "[Always Request Search Conditions](/en/manual/table-management-always-request-search-condition)" is turned on in "「Table Management」", records will not be displayed unless one or more filters are set. 1. If "[View Save Type](/en/manual/dashboard-view)" is disabled in "「Table Management」", the filter will be released when you transition to a new screen. 1. Search results may differ between when using SQL Server and when using PostgreSQL. While SQL Server uses the LIKE clause or "[Full Text Search](/en/manual/faq-search)", PostgreSQL uses the ILIKE clause or "[Full Text Search](/en/manual/faq-search)" using pg_trgm. 1. This function can only be used on the list screen. It cannot be used on "[View](/en/manual/table-record-view)" or "[Server Script](/en/manual/table-management-server-script)", etc. ## Prerequisites 1. The item to be searched must be enabled in "[Filter](/en/manual/table-record-search)". 1. The item to be searched must be enabled in "[List](/en/manual/table-management-grid)" or "[Editor](/en/manual/table-management-editor)". If the item is enabled in "[Filter](/en/manual/table-record-search)" but disabled in "[List](/en/manual/table-management-grid)" or "[Editor](/en/manual/table-management-editor)", the filter will not be displayed on the screen. ## Operation Method Mouse over the filter label to display the negation menu, and select "Negation" or "Affirmation". | Item | Description | |----|----| | Negation | Perform a search for negated conditions. A "!" icon indicating a search for negated conditions is displayed at the beginning of the label. | | Affirmation | Perform a normal search. If a "!" icon indicating a search for negated conditions is displayed at the beginning of the label, it will be hidden. | The negation condition of each item is the result of negating the normal search condition of "[Filter](/en/manual/table-record-search)". If the normal search result for a certain item is A and the negated search result is B, the search result A + B will be the entire record. For detailed specifications of normal search conditions, please refer to the following manual. [Table Function: Search for Negated Record (filter)](https://pleasanter.org/manual/table-record-search) ### "Incomplete" Checkbox Select "Negation" with the checkbox on will search for records that <font color="red">are not</font> "Incomplete". ### "Self" Checkbox Select "Negation" with the checkbox on will search for records where the "Administrator" and "Person In Charge" items <font color="red">are not</font> the logged-in user. ### "Due Soon" Checkbox Select "Negation" with the box checked will search for records that <font color="red">are not within</font> the "Due Soon" range. ### "Delay" Checkbox Select "Negation" with the box checked will search for records that <font color="red">are not</font> "Delay". ### "Overdue" Checkbox Select "Negation" with the box checked will search for records that <font color="red">are not</font> "Overdue". ### "Classification", "Title", "Content", and "Description" Text Boxes Select "Negation" with a string entered will search for records that <font color="red">do not contain</font> the entered string. If "Negation" is selected while a half-width or full-width space is entered in the text box, records that the item <font color="red">is not</font> blank will be searched for. ### "Classification", "「Status」", "Manager", "Contact" Drop-Down Lists Select "Negation" with the search target checked from the drop-down list will search for records <font color="red">other than</font> the checked targets. If multiple options are checked and "Negation" is selected, the search will be performed using the negative AND condition. If "Negation" is selected with (Unset), records that the option <font color="red">is not</font> blank will be searched for. ### "Numerical Value", "Workload", and "Progress Rate" Drop-Down Lists Select "Negation" with the search target checked from the drop-down list will search for records <font color="red">other than</font> the checked targets. If "Negation" is selected with multiple choices checked, the search will be performed using the <font color="red">AND condition of negation</font>. If "Negation" is selected while "(Unset)" is selected, records that the numerical value <font color="red">is not</font> unset will be searched for. ### "Numerical Value", "Workload", and "Progress Rate" Text Boxes If "Select Mode" is set to "「Range」" in the detailed filter settings, selecting "Negation" with numerical values entered in the "Start" and "End" fields will search for records that <font color="red">are not within</font> the entered numerical value range. If "Negation" is selected while only "Start" is entered, records that <font color="red">are not</font> greater than or equal to the value entered in "Start" ( = less than the value entered in “Start”) are retrieved. If "Negation" is selected while only "End is entered, records that <font color="red">are not</font> less than or equal to the value entered for “End” ( = exceed the value entered for “End”) will be searched for. ### "Date", "Created Datetime", and "Updated Datetime" Drop-Down Lists By selecting "Negation" with the choice indicating the range of dates to be searched checked from the drop-down list, records <font color="red">other than</font> those checked will be searched. If "Negation" is selected with multiple choices checked, the search will be performed using the <font color="red">AND condition of negation</font>. If "Negation" is selected with (Unset) selected, records with the date that <font color="red">is not</font> blank will be searched for. ### "Date", "Created Datetime", and "Updated Datetime" Text Boxes If "Select Mode" in the advanced filter settings is set to "「Range」", selecting "Negation" when dates are entered in the "Start" and "End" fields will search for records that <font color="red">are not within</font> the entered date range. If "Negation" is selected when only "Start" is entered, records that <font color="red">are not</font> greater than or equal to the date entered in "Start" (= less than the date entered in "Start") will be searched for. If "Negation" is selected when only "End" is entered, records that <font color="red">are not</font> less than or equal to the date entered in "End" (= exceeding the date entered in "End") will be searched for. ### "Check" and "Lock" Checkboxes By selecting "Negation" with the check box selected, you can search for records that <font color="red">are not</font> checked. ### "Check" and "Lock" Drop-Down Lists If "[Control Type](/en/manual/table-management-control-type)" is set to "On" or "Off" in the filter advanced settings, selecting "On" and then "Negation" will search for records that <font color="red">are not</font> checked. Selecting "Off" and then "Negation" will search for records that are not unchecked. ### Attachment File Items There is no search function for attachment items. ### Search By selecting "Negation" with a string entered in the "[Search](/en/manual/table-management-search)" text box, records that <font color="red">do not contain</font> the entered string will be searched. If a space is used to separate words and "Negation" is selected, the search will be performed using the <font color="red">OR condition of negation</font>. If “or” is entered between words and "Negation" is selected, a search is performed using the <font color="red">AND condition of negation</font>. ## Reset When you press the "Reset" button, all filter conditions will return to the settings of the selected view. ## 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> <li><a href="/en/manual/table-calendar">Table Function: Calendar Display of Records</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-editor">Table Management: Editor</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-control-type">Table Management: Editor: Item Detail Settings: Control Type (Numerical)</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-choices-text-users">Table Management: Editor: Item Detail Settings: Option List: User</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-grid">Table Management: List Screen</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-always-request-search-condition">Table Management: List screen: Always Request Search Conditions</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-filter-check-filter-control-type">Table Management: Filter: Check Item Filter Control Type</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/table-management-search">Table Management: Search</a><span>08.13.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-calendar">Table Management: Calendar</a><span>08.13.2024 up</span></li> <li><a href="/en/manual/table-management-gantt">Table Management: Gantt Chart</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/dashboard-view">Dashboard Function: View Save Type</a><span>08.14.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> <ul><li><a href="/en/manual/faq-search">FAQ: No Search Results</a><span>08.14.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />