# Table lower cases all column headers except the first one

**URL:** <https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581>\
**Category:** Ignition\
**Created:** [January 28, 2011, 10:38pm UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581 "2011-01-28T22:38:42Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [January 28, 2011, 10:38pm UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/1 "2011-01-28T22:38:42Z")

</div>

I’m sure it didn’t do this before.

---

<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:** [January 28, 2011, 11:28pm UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/2 "2011-01-28T23:28:14Z")

</div>

Well, the table headers come from the dataset column name initially. You can override the header in the table customizer and set it to whatever you would like. Check your SQL query or underlying dataset.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [January 29, 2011, 12:11am UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/3 "2011-01-29T00:11:57Z")

</div>

My query clearly has capitals in the column names. If fact I am renaming the columns in the query.  
I have also tried editing the column names in the customizer dataset.  
Still only the first column is capitalized.

Sample query:

` "SELECT name as \"Point Name\" ,intvalue as State ,\
        case dataintegrity when 192 then 'Good'\
                           when 32 then 'Not Reported'\
                           when 24 then 'Comm Failed'\
                           else 'BAD'\
        end as Status\
        FROM sqlt_core\
        WHERE path = '"+event.source.parent.Device+"/' and datatype = 6"
`

---

<div class="post-metadata">

**Author:** ![dep05d](https://avatars.discourse-cdn.com/v4/letter/d/e495f1/32.png) [@dep05d](https://forum.inductiveautomation.com/u/dep05d)\
**Post date:** [January 29, 2011, 12:35am UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/4 "2011-01-29T00:35:20Z")

</div>

I think it’s the double quotes around the column name in the select statement. By default, the column names are case insensitive. Quotes will preserve the case of the column name, while a lack of quotes will default to lower case for MySQL, upper case for Oracle, etc.

Dan

---

<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:** [January 29, 2011, 12:55am UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/5 "2011-01-29T00:55:25Z")

</div>

Is your table’s data dataset bound to a SQL query or a runScript expression? For me if I bind the dataset to a SQL query it gives me the correct column headers. Maybe you can send a copy of the window with the problem for us to check out?

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [January 29, 2011, 3:58am UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/6 "2011-01-29T03:58:51Z")

</div>

```auto
I think it's the double quotes around the column name in the select statement.
```

I’m talking to a Postgres DB. The double quotes are required because of the space in “Point Name”.  
Single qoutes causes errors and he select fails to execute, as does no quotes.

Of course now that I think about it, the first column _is_ the one column name that is quoted so maybe that’s why the column name works. I’ll give it try later.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [January 31, 2011, 4:47pm UTC](https://forum.inductiveautomation.com/t/table-lower-cases-all-column-headers-except-the-first-one/2581/7 "2011-01-31T16:47:12Z")

</div>

You got it Travis. After quoting the other column names, they all displayed correctly.  
Must be a PostGres thing. 👿