# Coluna não aparece em coluna de consulta

**URL:** <https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415>\
**Category:** Report a Bug\
**Created:** [January 9, 2024, 3:14pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415 "2024-01-09T15:14:56Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\
**Post date:** [January 9, 2024, 3:14pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/1 "2024-01-09T15:14:56Z")

</div>

uma serie de colunas não estão aparcendo em uma consulta, minha tabela tem 177 colunas as ultimas que criei não aparecem.

alguem pode me ajudar por favor.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 9, 2024, 3:38pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/2 "2024-01-09T15:38:32Z")

</div>

Can you share some more information? How did you add the columns? How are you trying to view the query?

---

<div class="post-metadata">

**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\
**Post date:** [January 9, 2024, 3:59pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/4 "2024-01-09T15:59:03Z")

</div>

Estou tentando usar math colunm, e essas colunas não aparecerem, e elas estão visiveis na tabela, mais quando tento selecionar elas não estão visiveis

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 9, 2024, 4:02pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/5 "2024-01-09T16:02:43Z")

</div>

I’m still not clear? Trying to select them where? For what? Do you have screenshots of what you are trying to do?

---

<div class="post-metadata">

**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\
**Post date:** [January 9, 2024, 5:36pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/6 "2024-01-09T17:36:37Z")

</div>

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/d/ed97e9adc4e6deefafbd101de2cb5c49f98d3098.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/ded40c854fb7b918e0dd9e7782ced516b3edadec.jpeg)  
NOME SERIA (ESTOQUE BAR)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 9, 2024, 5:48pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/7 "2024-01-09T17:48:30Z")

</div>

Are you trying to get a value from the query to use in your math column?

If so there are two problems. The first problem is that a query (like a relation) will only return rows. It does not return a specific columns. The second problem is that a query column is like a multiple relation and can potentially link to multiple rows.

If you use a relation, you can make it a single relation and then add Lookup columns to retrieve values from the relation. But since you are using a query, you will need to use a Single Value column to retrieve values from the query.

One you have the Single Value column created, you should be able to use it in your math column.

---

<div class="post-metadata">

**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\
**Post date:** [January 9, 2024, 6:21pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/8 "2024-01-09T18:21:38Z")

</div>

Mais jeff estou usando isso em outras colunas some nessa deu esse problema, as outras são iguais, muda somente o nome.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 9, 2024, 6:32pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/9 "2024-01-09T18:32:34Z")

</div>

I must be misunderstanding something but I don’t know what I’m missing. I see that you have several query columns and a math column, but I don’t understand how you expect them to work together. Query columns do not contain single column values on their own. You need to retrieve a value out of that Query using a Single Value column before you can use it in a math column. That is how it has always worked. I don’t know what you are saying has worked before but I can assure you that you are not using a Query column in a Math column.

---

<div class="post-metadata">

**Author:** ![wendel\_ferreira](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wendel_ferreira/32/19580_2.png) [@wendel\_ferreira](https://community.glideapps.com/u/wendel_ferreira)\
**Post date:** [January 9, 2024, 7:07pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/10 "2024-01-09T19:07:51Z")

</div>

Essas colunas estão fazendo uma consulta e retornando um valor, o relacionamento esta em outra coluna.

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 9, 2024, 7:11pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/11 "2024-01-09T19:11:47Z")

</div>

Again, if you need a value in that Query, you need to add a Single Value column to get that value out of the Query.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [July 7, 2024, 7:11pm UTC](https://community.glideapps.com/t/coluna-nao-aparece-em-coluna-de-consulta/69415/12 "2024-07-07T19:11:48Z")

</div>

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.
