# Azure-table-storage-aleph query

**URL:** <https://discourse.nodered.org/t/azure-table-storage-aleph-query/74467>\
**Category:** General\
**Created:** [31 January 2023 09:20 UTC](https://discourse.nodered.org/t/azure-table-storage-aleph-query/74467 "2023-01-31T09:20:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dineshaj](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dineshaj/32/53342_2.png) [@dineshaj](https://discourse.nodered.org/u/dineshaj)\
**Post date:** [31 January 2023 09:20 UTC](https://discourse.nodered.org/t/azure-table-storage-aleph-query/74467/1 "2023-01-31T09:20:58Z")

</div>

Hi,

I would like to query my table to return values of the column named "groupId". I am not able to understand the documentation for the query string which is

```auto
{
  "tableName": "MyTable", 
  "action": "Q", 
  "selectdata": "groupId", 
  "fromcolumn": "from", 
  "where": "equalCondition",
  "top": 5
}

```

I am getting confused about fromcolumn and where clause.

Thanks,

---

<div class="post-metadata">

**Author:** ![dineshaj](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dineshaj/32/53342_2.png) [@dineshaj](https://discourse.nodered.org/u/dineshaj)\
**Post date:** [1 February 2023 08:27 UTC](https://discourse.nodered.org/t/azure-table-storage-aleph-query/74467/2 "2023-02-01T08:27:20Z")

</div>

This works

{  
"tableName": "MyTable",  
"action": "Q",  
"selectdata": "",  
"fromcolumn": "groupId",  
"where": "580",  
"top": 5  
}

Mentioned groupID in the where clause and it returns all the rows. Returns everything even I put any column name in "selectdata"

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 February 2023 08:27 UTC](https://discourse.nodered.org/t/azure-table-storage-aleph-query/74467/3 "2023-02-15T08:27:33Z")

</div>

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