OCLOperators ExecutePS
(Automatically adding template at the end of the page.)
(Adding message template to the top of the page)
Line 1: Line 1:
{{message|Write the content here to display this box}}
==== NOTE: Consider using selfVM.[[OCLOperators PSEval|PSEval]] instead of this for new development ====
==== 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.
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.

Revision as of 22:21, 16 June 2024

Write the content here to display this box

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