Skip to content

Table Function: Search for Negated Record (Filter)

Overview

By operating the Negation menu in the "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" is set to "Session" or "User", the filter you set will be retained even after transitioning to other screens. The filter works in chart screens such as "Calendar" and "Gantt Chart" in the same way as in the screen index.

Filter with the Negation menu used to narrow records down

Supported Versions

  1. Pleasanter 1.3.18.0 or later

Limitations

  1. If "Always Request Search Conditions" is turned on in "Manage Table", records will not be displayed unless one or more filters are set.
  2. If "View Save Type" is disabled in "Manage Table", the filter will be released when you transition to a new screen.
  3. Search results may differ between when using SQL Server and when using PostgreSQL. While SQL Server uses the LIKE clause or "Full Text Search", PostgreSQL uses the ILIKE clause or "Full Text Search" using pg_trgm.
  4. This function can only be used on the screen index. It cannot be used on "View" or "Server Script", etc.

Prerequisites

  1. The column to be searched must be enabled in "Filter".
  2. The column to be searched must be enabled in "Index" or "Editor". If the column is enabled in "Filter" but disabled in "Index" or "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". 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)

"Incomplete" Checkbox

Select "Negation" with the checkbox on will search for records that are not "Incomplete".

"Own" Checkbox

Select "Negation" with the checkbox on will search for records where the "Manager" and "Owner" columns are not the logged-in user.

"Due Soon" Checkbox

Select "Negation" with the box checked will search for records that are not within the "Due Soon" range.

"Delay" Checkbox

Select "Negation" with the box checked will search for records that are not "Delay".

"Overdue" Checkbox

Select "Negation" with the box checked will search for records that are not "Overdue".

"Classification", "Title", "Content", and "Description" Text Boxes

Select "Negation" with a string entered will search for records that do not contain 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 is not 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 other than the checked targets. If multiple options are checked and "Negation" is selected, the search will be performed using the AND condition of negation. If "Negation" is selected with (Unset), records that the option is not 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 other than the checked targets. If "Negation" is selected with multiple choices checked, the search will be performed using the AND condition of negation. If "Negation" is selected while "(Unset)" is selected, records that the numerical value is not 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 are not within the entered numerical value range. If "Negation" is selected while only "Start" is entered, records that are not 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 are not 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 other than those checked will be searched. If "Negation" is selected with multiple choices checked, the search will be performed using the AND condition of negation. If "Negation" is selected with (Unset) selected, records with the date that is not 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 are not within the entered date range. If "Negation" is selected when only "Start" is entered, records that are not 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 are not 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 are not checked.

"Check" and "Lock" Drop-Down Lists

If "Control Type" is set to "On" or "Off" in the advanced filter settings, selecting "On" and then "Negation" will search for records that are not checked. Selecting "Off" and then "Negation" will search for records that are not unchecked.

Attachment File Columns

There is no search function for attachment columns.

By selecting "Negation" with a string entered in the "Search" text box, records that do not contain 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 OR condition of negation. If “or” is entered between words and "Negation" is selected, a search is performed using the AND condition of negation.

Reset

When you press the "Reset" button, all filter conditions will return to the settings of the selected view.