Documentation:OCLOperators ExecutePS: Difference between revisions

OCLOperators ExecutePS

Revision as of 08:46, 2 March 2023

This page was created by Hans.karlsen@mdriven.net on 2018-07-13. Last edited by Charles@mdriven.net on 2025-03-12.

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).

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.

@@ Line 1: / Line 1: @@
-selfVM.ExecutePS() is used to use the power and speed of the database to find a subset of objects of a certain type in a ViewModel.
+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, the 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
+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 root level column and limit returned values.
+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 [[How_to_use_the_ExecutePS_function_in_selfVM]]
+[[File:2018-07-13 14h41 13.png|none|thumb|692x692px]]See also: [[How_to_use_the_ExecutePS_function_in_selfVM]]
 [[Category:OCLOperators]]