# Expression/SQL Binding in Data Types

**URL:** <https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461>\
**Category:** Ignition\
**Created:** [May 17, 2014, 5:56am UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461 "2014-05-17T05:56:57Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [May 17, 2014, 5:56am UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/1 "2014-05-17T05:56:57Z")

</div>

Hello!

1. I was create some internal Tag Provider
2. In this tag provider i was create new Data Type with properties: Floor, Number and other
3. In this Data Type i was create new Expression tag which want must bind to tags in Default folder of tags.
4. When i choose in this Expression tag address of Default tag i saw this:

```auto
{Manufactura/Floor_3/Room_1/Flooding}
```

1. I want to use like this:

```auto
{Manufactura/Floor_{Floor}/Room_{Number}/Flooding}
```

where Floor and Number - properties of Data Type  
This structure is wrong  
How i must to use this to right binding?  
[attachment=0]1.jpg[/attachment]

---

<div class="post-metadata">

**Author:** ![george](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/george/32/14066_2.png) [@george](https://forum.inductiveautomation.com/u/george)\
**Post date:** [May 19, 2014, 8:04am UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/2 "2014-05-19T08:04:41Z")

</div>

I think you need to use the expression function tag, as follows:

`tag("Manufactura/Floor_" + {[.]Floor} + "/Room_" + {[.]Number} + "/Flooding")
`

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [May 29, 2014, 12:00pm UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/3 "2014-05-29T12:00:32Z")

</div>

Trying this:  
tag(“Manufactura/Boiling/boiler/UniversalChar/UnC6”)  
Taking this:  
[attachment=0]screenshot.jpg[/attachment]

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [May 30, 2014, 9:54am UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/4 "2014-05-30T09:54:53Z")

</div>

Any ideas?

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [May 30, 2014, 11:45am UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/5 "2014-05-30T11:45:24Z")

</div>

Your picture/image/photo shows “Manufactura” as the [Tag Provider](http://inductiveautomation.com/support/usermanuals/ignition/sqltags_overview.htm).  
Try this instead:

Expression:

```auto
tag("[Manufactura]Boiling/boiler/UniversalChar/UnC6")
```

or (Expression):

```auto
tag("[Manufactura]Floor_" + {[.]Floor} + "/Room_" + {[.]Number} + "/Flooding")
```

---

<div class="post-metadata">

**Author:** ![Serhii](https://avatars.discourse-cdn.com/v4/letter/s/df788c/32.png) [@Serhii](https://forum.inductiveautomation.com/u/Serhii)\
**Post date:** [May 30, 2014, 7:20pm UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/6 "2014-05-30T19:20:32Z")

</div>

I want to use tags not from this Tag Provider.

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [May 30, 2014, 9:34pm UTC](https://forum.inductiveautomation.com/t/expression-sql-binding-in-data-types/8461/7 "2014-05-30T21:34:46Z")

</div>

I don’t understand. Just make sure that that first folder is using the same syntax. Try this:

Expression:

```auto
tag("[Cosmopolite]Whatever/Tag")
```

or (Expression):

```auto
tag("[Hodoseevka]Some_" + {[Cosmopolite]Whatever/Tag} + "/Other/Tag")
```