OCLOperators ExecutePS
No edit summary
(Automatically adding template at the end of the page.)
(6 intermediate revisions by 3 users not shown)
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.
==== NOTE: Consider using selfVM.[[OCLOperators PSEval|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 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
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]]
[[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]]
{{Edited|July|12|2024}}

Revision as of 15:38, 10 February 2024

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

NOTE: Consider using selfVM.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.

2018-07-13 14h41 13.png

See also: How_to_use_the_ExecutePS_function_in_selfVM

MDriven Chat

How would you like to chat today?

Setting up your conversation…

This may take a few moments