OCLOperators ExecutePS
(Replacing message template with parser tag)
No edit summary
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<message>Write the content here to display this box</message>
<message>Write the content here to display this box</message>
==== NOTE: Consider using selfVM.[[OCLOperators PSEval|PSEval]] instead of this for new development ====
==== NOTE: Consider using [[Documentation:OCLOperators PSEval|<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.
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.


Line 8: Line 8:


ExecutePS will look for MaxFetch taggedvalue on the 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 also: [[How_to_use_the_ExecutePS_function_in_selfVM]]
[[File:2018-07-13 14h41 13.png|none|thumb|692x692px]]See also: [[Documentation:How to use the ExecutePS function in selfVM|How_to_use_the_ExecutePS_function_in_selfVM]]
 
{{Edited|July|12|2025}}
[[Category:OCLOperators]]
[[Category:OCLOperators]]
[[Category:OCL ViewModel Operators]]
[[Category:OCL ViewModel Operators]]
{{Edited|July|12|2024}}

Latest revision as of 22:44, 12 March 2025

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

2018-07-13 14h41 13.png

See also: How_to_use_the_ExecutePS_function_in_selfVM