OCLOperators ExecutePS
This page was created by Hans.karlsen on 2018-07-13. Last edited by Charles on 2025-03-12.
NOTE: Consider using <Class>.PSEval instead of this for new development
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.