Skip to content

Displaying "The specified information was not found." When Setting a Value with $p.set on a Classification Column with ColumnFilterExpressions

Answer

If you are using ColumnFilterExpressions on a class column with "Use Search Function" enabled, make sure to also set a value for the column specified in ColumnFilterExpressions at the same time you call $p.set.

Overview

Conditions

The error occurs when all of the following conditions are met:

  1. "Use Search Function" is enabled on a "Class" column
  2. The "Choice List" is written in JSON format using ColumnFilterExpressions
  3. $p.set sets a value only on the target class column, without setting a value on the column specified in ColumnFilterExpressions

Error Message

The specified information was not found.

Cause

ColumnFilterExpressions generates a dropdown list based on the value entered in another column. When "Use Search Function" is enabled, Pleasanter runs a process that searches for the selected record from the choice list and retrieves its title to display on screen.

Therefore, if $p.set sets a value on a "Class" column while the column specified in ColumnFilterExpressions has no value, the title retrieval search runs against a non-existent choice list, resulting in the error.

Workaround

When setting a value with $p.set on a class column, also set a value on the column specified in ColumnFilterExpressions at the same time.