Using an argument(s) with the view function?

Paging @pturmel

I am trying to use a view with a where statement that is looking to a custom root container property.

Currently my expression is
view("SELECT * WHERE someColumn=args0",{Root Container.initialDataset}, {Root Container.idx})
but this is not working. I'm not sure the correct syntax - I can't find it in the documentation or an example in the demo project. How can I use my Root Container.idx in the pseudo SQL here?

Looks like args[0]:
https://www.automation-pros.com/simaids/doc/expression.objectscript.html
https://www.automation-pros.com/simaids/doc/expression.view.html

The Where clause may use the munged names of the source columns, objects normally present in the local scope (system.*, etc.), the "args" and "binding" objects as described in the objectScript expression function, and "_r", the row index in the source dataset.

2 Likes

Yup, args is a tuple.