# View Expression Binding Formatting

**URL:** <https://forum.inductiveautomation.com/t/view-expression-binding-formatting/76581>\
**Category:** Ignition\
**Created:** [July 19, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/view-expression-binding-formatting/76581 "2023-07-19T13:42:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![pbg](https://avatars.discourse-cdn.com/v4/letter/p/ecd19e/32.png) [@pbg](https://forum.inductiveautomation.com/u/pbg)\
**Post date:** [July 19, 2023, 1:42pm UTC](https://forum.inductiveautomation.com/t/view-expression-binding-formatting/76581/1 "2023-07-19T13:42:22Z")

</div>

Hi, I'm having a little trouble working with the view expression binding syntax even while using documentation. Below I am trying to select the rows of Tag Name (string) where UDT Header ID (int) is Dropdown value (int) but I only get what is shown in the below screenshot. I know I am probably just misunderstanding some syntax.

```auto
view("SELECT 'Tag Name' WHERE 'UDT Header ID'==args[0]",{parent.custom.UDTDetails},{../FlexContainer/FlexContainer/udtTypeDropdown.props.value})

```

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/8/d8635c74d77434b89e39eaee2035c57e56664e9b.png)

---

<div class="post-metadata">

**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:** [July 19, 2023, 1:55pm UTC](https://forum.inductiveautomation.com/t/view-expression-binding-formatting/76581/2 "2023-07-19T13:55:37Z")

</div>

> [@pbg](#):
>
> I know I am probably just misunderstanding some syntax.

Yup. You are asking for the literal string `'Tag Name'` to be delivered for matching rows, and `view()`, in the absence of an `AS` clause, munges that to produce a column name. You received no rows because your `args[0]` doesn't contain the literal string `'UDT Header ID'`.

When a source dataset has column names that aren't valid python variable names, you must use the munged version (without any quotes) in your python expressions within the pseudo-SQL.

{ I recommend using compliant column names in your datasets. }

Try this:

```auto
view(
  "SELECT Tag_Name WHERE UDT_Header_ID==args[0]",
  {parent.custom.UDTDetails},
  {../FlexContainer/FlexContainer/udtTypeDropdown.props.value}
)

```
