OCLOperators ExecutePS
Hans Karlsen (talk | contribs) 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 | ==== 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 | 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 | 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 15:38, 10 February 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.
This page was edited 101 days ago on 02/10/2024. What links here