# Expression length limit?

**URL:** <https://forum.inductiveautomation.com/t/expression-length-limit/4105>\
**Category:** Ignition\
**Created:** [March 5, 2012, 9:29pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105 "2012-03-05T21:29:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\
**Post date:** [March 5, 2012, 9:29pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105/1 "2012-03-05T21:29:17Z")

</div>

is the length of the expression limited ?  
I try to use it to compute a group of alarm tag for each equipement with 9 defects:  
({[.]Defauts/Affichage.AlertCurrentSeverity}=4)||  
({[.]Defauts/AnnonceSonore.AlertCurrentSeverity}=4)||  
({[.]Defauts/Batterie.AlertCurrentSeverity}=4)||  
({[.]Defauts/Communication.AlertCurrentSeverity}=4))||  
({[.]Defauts/Horloge.AlertCurrentSeverity}=4)||  
({[.]Defauts/RetroEclairage.AlertCurrentSeverity}=4)||  
({[.]Defauts/SauvegardeMemoire.AlertCurrentSeverity}=4)||  
({[.]Defauts/Temperature.AlertCurrentSeverity}=4)||  
({[.]Defauts/Transmission.AlertCurrentSeverity}=4)  
Another solution ?

---

<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 6, 2012, 3:56pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105/2 "2012-03-06T15:56:42Z")

</div>

What type of SQLTags realtime provider are you using? Internal or external (database driving provider)? If it is in the database you need to expand the length of the string column stringval in the sqlt\_meta table.

---

<div class="post-metadata">

**Author:** ![ecujak](https://avatars.discourse-cdn.com/v4/letter/e/839c29/32.png) [@ecujak](https://forum.inductiveautomation.com/u/ecujak)\
**Post date:** [March 6, 2012, 6:25pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105/3 "2012-03-06T18:25:54Z")

</div>

> [@Travis.Cox](#):
>
> If it is in the database you need to expand the length of the string column stringval in the sqlt\_meta table.

Travis, Can you give an example?

---

<div class="post-metadata">

**Author:** ![Greg.Buehler](https://avatars.discourse-cdn.com/v4/letter/g/ecc23a/32.png) [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\
**Post date:** [March 6, 2012, 7:29pm UTC](https://forum.inductiveautomation.com/t/expression-length-limit/4105/4 "2012-03-06T19:29:18Z")

</div>

What flavor of SQL database are you using?