How to use the ExecutePS function in selfVM

NOTE: ExcutePS is replaced with selfVM.PSEval - use that instead for new stuff

This is a practical reference example of how to use the ExceutePS function from a ViewModel. There are many possible uses, but this one is fairly descriptive.

Need: Look up all the objects with the same value as one particular object. Maybe the user wants to know if something is unique or not…

The Model:

Execute -1.png

The ViewModel:

Execute -2.png

Set the vValueToMatch to the Attribute1 of the ViewModel root Thing. Then, call the ExecutePS, stating that it will get a result collection with the objects of type Thing if it runs the expression found in OutOfLoopToAvoidStdFetch.col1. Collect this result and add the objects to a list you added as a variable – vMyList.

The list can act as a root for Grid in the UI.

If you have a million Thing objects in the database, this ViewModel will only load the ones with the same attribute1 as the Thing object you started with.

See: OCLOperators_ExecutePS

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