Stack Overflow
Stack Overflow

Questions tagged [azure-tablequery]

126 questions
0
votes
1 answer

Azure Table Storage: How do you group AND and OR Queries Utilizing NodeJS Library?

Utilizing the manual editor in Azure Storage Explorer I can create the following query that returns the results I want from the Azure Table Storage: TYPE eq 'MYTYPE' and (PartitionKey eq '1' or PartitionKey eq '2') However, I'm not sure how to do…
Doug
  • 6,446
  • 9
  • 74
  • 107
0
votes
1 answer

Cannot find an overload for “ExecuteQuerySegmentedAsync” and the argument count: “2” in Get-AzTableRow

I am trying use the Get-AzTableRow to retrieve a Azure Table row, followed by updating it. But the cmdlet is throwing the below errors: PS C:\WINDOWS\system32> Get-AzTableRow -ColumnName "NsgName" -Value "subnet1invnet4-nsg" -Operator "Equal" …
Sayantan Ghosh
  • 998
  • 2
  • 9
  • 29
0
votes
1 answer

Query Azure database using API

I host my database on Azure. I would like to search data on the table in that database. I am trying to use B4I and the tech help their said I need to use REST API's. I am pretty sure I need to use ODATA. I have the auth token but I am not sure…
Graemem
  • 11
  • 3
0
votes
0 answers

Sort by the most recent to the oldest in Azure Cosmos Table not working

According to this article https://learn.microsoft.com/en-us/azure/cosmos-db/table-storage-design-guide#log-tail-pattern, if save RowKey to string invertedTicks = string.Format("{0:D19}", DateTime.MaxValue.Ticks - DateTime.UtcNow.Ticks); then I can…
Linda Liu
  • 31
  • 1
0
votes
0 answers

Updating different columns of same row in AZURE table by multiple threads at same time

I have a requirement where I have to update different columns of the same row in azure table which is accessed by multiple threads simultaneously (all querying for the same row) without overwriting what the other thread would have updated. Sample…
Iquery
  • 103
  • 1
  • 10
0
votes
2 answers

querying complex type in Azure Table

I am new to NoSql concepts. Coming from a mind set of "ModelFirst" i usually design my models first. I have a model as follows. public class Book { public string Name { get; set; } [EntityPropertyConverter(typeof(Category))] public…
Raas Masood
  • 1,475
  • 3
  • 23
  • 61
0
votes
1 answer

How to retrieve all entities in Azure Table DB?

The code below retrieves all entities where PartitionKey = "Smith". If I want to eliminate this constraint and return all entities in the table, how should I modify the below code? Sorry if it seems a silly question, but I am new to C# and AzureDBs,…
user3531660
  • 15
  • 2
  • 9
0
votes
1 answer

Can I get a race condition on Azure table insert operation?

I have a Function app that inserts some data into a Azure table. Is it possible that I will get a race condition and end up inserting data with the same ID twice, or does Azure make the Insert operations under some table level lock that would ensure…
Shane
  • 369
  • 1
  • 2
  • 13
0
votes
1 answer

Azure TableEntity EntityResolver to Call and re-use base resolving functionality

I'm creating a custom EntityResolve, so that when I retrieve my azure table records, I will set a bunch of properties on the Business Object (TableEntity object) that are designed only to be used in my app and not persisted back to the Azure table. …
user1060500
  • 1,505
  • 1
  • 21
  • 40
0
votes
1 answer

Azure Function : How to see if a record exists in Table Storage

Note : this is for an Azure Function. The normal C# links on microsoft docs do not apply. It is for an Azure Function. Scenario: I need to have 1 entry only per Person, with the last date that this person logged in. This property gets updated every…
Peter PitLock
  • 1,823
  • 7
  • 34
  • 71
0
votes
0 answers

What is RowIndex in WADLogs table?

How is RowIndex calculated in azure diagnostic WADLogs table ? I saw that it is not in a consecutive order across rows. Is it a randomly generated unique number ? RowKey contains RowIndex as its last segment of its string. Knowing how RowIndex is…
Tany
  • 1,252
  • 14
  • 30
0
votes
1 answer

Do Azure Table Query 'OR' Predicates Cause a Scan?

Assume the following query: PartitionKey==1 AND (RowKey==A OR RowKey==B) or even this: (PartitionKey==1 AND RowKey==A) OR (PartitionKey==2 AND RowKey==B) Do either of these result in a scan? I ask because this PDC talk indicates that it…
Agendum
  • 1,697
  • 1
  • 18
  • 36
0
votes
1 answer

Get download speed when ExecuteQuerySegmented is called

I know for the fact that ExecuteQuerySegmented runs the query against the Azure Table Storage. I would like to know on how can I output the download speed when ExecuteQuerySegmented is called? Something like: var queryResult =…
Joseph
  • 502
  • 4
  • 15
0
votes
1 answer

Azure Table Storage: Translate C# to NodeJS - How to use CompareTo?

There are a lot of examples circulating around the internet about how you can use CompareTo with Azure Table Storage to basically do some substring searching from C# , but I can't find anything showing how to do it in NodeJS and all the syntaxes…
Doug
  • 6,446
  • 9
  • 74
  • 107
0
votes
1 answer

Querying non-partition and non-row key in the Azure Table Storage

My table structure has a Partition key, Row key, and a column containing JSON data. I want to query the table based on the partition key and a particular value from the JSON data. Sample JSON Data: {"ConsumerId":"7","value01":"850.58"} The query I…
tRuEsAtM
  • 3,517
  • 6
  • 43
  • 83
1 2 3
…
8
9