Skip to content

view.OnSelectingWhere

Overview

This is the "OnSelectingWhere" of the "view object". It is used when dynamically specifying the "OnSelectingWhere" of the "Extended SQL" in the "Server Script".

Usage Examples

In the following example, the "Extended SQL" where Name is SelectingWhereName will be applied to users other than user ID 3.

JavaScript
if (context.UserId !== 3) {
    view.Filters.OnSelectingWhere = 'SelectingWhereName';
}
JSON
{
    "Name": "SelectingWhereName",
    "SpecifyByName": true,
    "OnSelectingWhere": true,
    "CommandText": "([Issues].[Status]=900)"
}

Supported Versions

  1. Pleasanter 1.2.2.0 or later
  2. Pleasanter .NET Framework version 0.50.265.0 or later