# Complex tag showing up as Int4 in SQL Tags

**URL:** <https://forum.inductiveautomation.com/t/complex-tag-showing-up-as-int4-in-sql-tags/5986>\
**Category:** Ignition\
**Created:** [March 7, 2013, 8:34pm UTC](https://forum.inductiveautomation.com/t/complex-tag-showing-up-as-int4-in-sql-tags/5986 "2013-03-07T20:34:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![eaolson](https://avatars.discourse-cdn.com/v4/letter/e/f07891/32.png) [@eaolson](https://forum.inductiveautomation.com/u/eaolson)\
**Post date:** [March 7, 2013, 8:34pm UTC](https://forum.inductiveautomation.com/t/complex-tag-showing-up-as-int4-in-sql-tags/5986/1 "2013-03-07T20:34:53Z")

</div>

We’re having a problem adding a PHASE tag from an Allen-Bradley ControlLogix processor to our SQL Tags. This is a fairly complex type, but it’s built-in, not a UDT. In the OPC Browser in Ignition, it shows up as a simple tag, not with the usual “folder” icon. Expanding it, however, shows all its component sub-tags. After dragging the phase tag to SQL Tags, it shows up as an Int4, and none of the sub-tags are present. It does display as expected in the OPC Quick Client on the Ignition gateway. Screenshots are attached.

We have a workaround: creating the folder manually with the name of the tag and drag all the sub-tags from the OPC Browser to the SQL Tags window seems to work.

Ignition version is 7.5.4 under Linux.  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/6/620993083460363cbe46e6b57b88f26702603cfb.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/9/9a54943dbfff645b495cfd9608a832e377e2f125.png)  
  
 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/5/5a791e09400ed89832bbba98848093a2615f7f78.png)

---

<div class="post-metadata">

**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\
**Post date:** [March 18, 2013, 9:13pm UTC](https://forum.inductiveautomation.com/t/complex-tag-showing-up-as-int4-in-sql-tags/5986/2 "2013-03-18T21:13:51Z")

</div>

For whatever reason the OPC server is giving us back the structure where the R\_PHASE is a tag and a folder. You are going to have to either create the folder manually and drag in the sub tags OR use the UDT feature of Ignition. I would model the UDT in the PLC as a UDT in Ignition so you only have to create it once. Here is a video on making UDTs:

[youtube.com/watch?v=lXSAnGUt … 4&index=46](http://www.youtube.com/watch?v=lXSAnGUtYCw&list=PL652395FCD92073F4&index=46)