Documentation:OCLOperators ExecutePS: Difference between revisions

OCLOperators ExecutePS

Revision as of 08:46, 2 March 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, 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.

This page was edited 95 days ago on 06/17/2024. What links here

@@ 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]]