OCLOperators ExecutePS
No edit summary
(Replacing message template with parser tag)
 
(9 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.
<message>Write the content here to display this box</message>
==== 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}}

Latest revision as of 07:47, 17 June 2024

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

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