# Named Query-Is it possible to only have one column show in a named query?

**URL:** <https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [August 30, 2022, 7:14pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620 "2022-08-30T19:14:51Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nicole\_Weiss](https://avatars.discourse-cdn.com/v4/letter/n/258eb7/32.png) [@Nicole\_Weiss](https://forum.inductiveautomation.com/u/Nicole_Weiss)\
**Post date:** [August 30, 2022, 7:14pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620/1 "2022-08-30T19:14:51Z")

</div>

Is it possible to only have one column show in a named query? I just want certain columns to show, not every column in my query database.

Thank you!

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [August 30, 2022, 7:23pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620/2 "2022-08-30T19:23:16Z")

</div>

If your named query is using something like

```auto
select * from table

```

then every single column will be selected from the database. You will want to explicitly select the columns you want

```auto
select foo, bar from table

```

Unless, you want to have certain columns returned from the query, but have some hidden in a table binding which is where you would use `columns` prop to make those certain ones not visible.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/6/969388196ceceed2549937fd9687e425dcfe1e25.png)

---

<div class="post-metadata">

**Author:** ![Nicole\_Weiss](https://avatars.discourse-cdn.com/v4/letter/n/258eb7/32.png) [@Nicole\_Weiss](https://forum.inductiveautomation.com/u/Nicole_Weiss)\
**Post date:** [August 30, 2022, 7:48pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620/3 "2022-08-30T19:48:08Z")

</div>

I do have the SELECT statement. This what I have:

SELECT ‘SHIFT’ FROM PUBLIC.“MES\_TABLES::PROCESS”

Then when I execute that statement I get:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/f/4f85b5a8b5cb926c0017ce1e6c8c762920eba9e3.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 30, 2022, 7:51pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620/4 "2022-08-30T19:51:17Z")

</div>

You are selecting the _literal string_ `'Shift'`, not a column named `Shift`. You must be very deliberate with use of quotes in most programming contexts.

I would expect:  
`SELECT SHIFT FROM PUBLIC.MES_TABLES::PROCESS`  
to work.

---

<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:** [August 30, 2022, 7:55pm UTC](https://forum.inductiveautomation.com/t/named-query-is-it-possible-to-only-have-one-column-show-in-a-named-query/63620/5 "2022-08-30T19:55:41Z")

</div>

In the SQL standard, single quotes are used for constant _ **values** _ and double quotes are used for _ **identifiers** _ like schema, table, and column names. Some brands support variations of the latter for backwards compatibility, but single quotes are always **values**.