# Using Simulation Aids and want to have where clause parameter bound to custom property? **URL:** \ **Category:** 3rd Party Modules\ **Tags:** perspective\ **Created:** [April 20, 2023, 7:04pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727 "2023-04-20T19:04:41Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [April 20, 2023, 7:04pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/1 "2023-04-20T19:04:41Z")
Paging Dr. @pturmel I know I've seen you mention this before but I don't see an example in the docs and I am having trouble finding it since searching for view brings up perspective posts. I have a expression that I am using to conditionally sum up a dataset like `view("sum(unitcost) WHERE accountId!=508 and Billed==? GROUP BY 1",{Root Container.DetailedView.inventoryListDetailed.data},{Root Container.idx})[0,0]` however, this is not working. I wanted the `Billed` column equal `Root Container.idx`. How can I do this? ---
**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\ **Post date:** [April 20, 2023, 7:35pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/2 "2023-04-20T19:35:58Z")
Change the `?` to `args[0]` ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [April 20, 2023, 7:56pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/3 "2023-04-20T19:56:14Z")
That was it, thank you! ---
**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\ **Post date:** [April 20, 2023, 7:57pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/4 "2023-04-20T19:57:55Z")
Happy to help! I love using the that `view` expression. Saves so much time. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [April 20, 2023, 7:59pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/5 "2023-04-20T19:59:10Z")
For what I have to do, which is have a group by line items from a dataset(so I can show things like quantity of the same part item #) where the user can edit the grouped by version or the raw dataset itself, it's a life saver. Really saves so much time. ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [April 20, 2023, 7:59pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/6 "2023-04-20T19:59:25Z")
I step out for a minute and people answer my questions for me. Have I said [that I love this community](https://forum.inductiveautomation.com/t/docker-set-web-xml-parameters-in-docker-compose/72640/13)? ❤ ---
**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\ **Post date:** [April 20, 2023, 8:00pm UTC](https://forum.inductiveautomation.com/t/using-simulation-aids-and-want-to-have-where-clause-parameter-bound-to-custom-property/72727/7 "2023-04-20T20:00:59Z")
Same here! I always like to lurk here to learn new / better ways of doing things