Documentation:OCLOperators ExecutePS: Difference between revisions

OCLOperators ExecutePS

Revision as of 06:08, 25 April 2023

selfVM.ExecutePS() is enabled to use the power and speed of the database to find a subset of objects of a certain type in a ViewModel.

In the example below, ExecutePS is used to look up License objects with PS (avoiding traversing all existing in memory).

The PS-evaluated expression (translated to SQL and executed in DB) is defined in a ViewModelColumn of its own that is not referenced by any UI.

ExecutePS will look for MaxFetch taggedvalue on the root level column and limit returned values.

This page was edited more than 11 months ago on 02/10/2024. What links here

@@ Line 1: / Line 1: @@
 selfVM.ExecutePS() is enabled to use the power and speed of the database to find a subset of objects of a certain type in a ViewModel.
-In the example below, the ExecutePS is used to look up License objects with ps (avoiding traversing all existing in memory).
+In the example below, ExecutePS is used to look up License objects with PS (avoiding traversing all existing in memory).
 The PS-evaluated expression (translated to SQL and executed in DB) is defined in a ViewModelColumn of its own that is not referenced by any UI.
 ExecutePS will look for MaxFetch taggedvalue on the root level column and limit returned values.
 [[File:2018-07-13 14h41 13.png|none|thumb|692x692px]]See also: [[How_to_use_the_ExecutePS_function_in_selfVM]]
 [[Category:OCLOperators]]
+[[Category:OCL ViewModel Operators]]