## Overview By operating the Negation menu in the "[Filter](/en/manual/table-management-filter)" at the top of the screen index, you can search for records with negation conditions for specific columns. 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-management-calendar)" and "[Gantt Chart](/en/manual/table-management-gantt)" in the same way as in the screen index.  ## 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 "[Manage Table](/en/manual/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 "[Manage Table](/en/manual/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 screen index. It cannot be used on "[View](/en/manual/table-management-view)" or "[Server Script](/en/manual/table-management-server-script)", etc. ## Prerequisites 1. The column to be searched must be enabled in "[Filter](/en/manual/table-management-filter)". 1. The column to be searched must be enabled in "「Index」" or "[Editor](/en/manual/table-management-editor)". If the column is enabled in "[Filter](/en/manual/table-management-filter)" but disabled in "「Index」" 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". | Column | 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 column is the result of negating the normal search condition of "[Filter](/en/manual/table-management-filter)". If the normal search result for a certain column 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". ### "Own" Checkbox Select "Negation" with the checkbox on will search for records where the "Manager" and "Owner" columns <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 column <font color="red">is not</font> blank will be searched for. ### "Classification", "[Status](/en/manual/table-management-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 <font color="red">AND condition of negation</font>. If "Negation" is selected with (Unset), records that the option <font color="red">is not</font> blank will be searched for. ### "Numerical Value", "Work Volume", and "Progression 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", "Work Volume", and "Progression rate" Text Boxes If "Select Mode" is set to "「Range」" in the advanced 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 numerical 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 numerical 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-filter-check-filter-control-type)" is set to "On" or "Off" in the advanced filter 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 <font color="red">are not</font> unchecked. ### Attachment File Columns There is no search function for attachment columns. ### 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-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">Manage Table</a><span>10.02.2024 up</span></li></ul></article> <ul><li><a href="/en/manual/table-management-status">Manage Table: Column: Status</a><span>10.02.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-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-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">Manage Table: Filter</a><span>10.02.2024 up</span></li> <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">Manage Table: View</a><span>10.03.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">Developer Function: JSON Data Layout: View</a><span>01.06.2025 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="" />