## Overview This is the ["OnSelectingWhere"](manual/faq-extended-sql-selecting-where) of the "view object". It is used when dynamically specifying the ["OnSelectingWhere"](manual/faq-extended-sql-selecting-where) of the "「Extended SQL」" in the "[Server Script](/en/manual/table-management-server-script)". ## Supported Versions 1. Pleasanter 1.2.2.0 or later 1. Pleasanter .NET Framework version 0.50.265.0 or later ## Usage Example 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)" } ``` ## Related Information <div id="ManualList"><ul><li><a href="/en/manual/table-management-server-script">Table Management: Server Script</a><span>08.13.2024 up</span></li></ul></article></div><input id="SearchTextHidden" type="hidden" value="" />