Questions tagged [azure-tablequery]
126 questions
0
votes
1 answer
Powershell: Pass result of Get-AzTableRow to function
I am using below PowerShell code in azure functions to retrieve rows of users in azure table who belongs to a particular location.
$Rows = Get-AzTableRow -table $cloudTable -customFilter "((Location eq '$loc') and (PartitionKey eq 'User'))"
Next, I…
alex devassy
- 437
- 5
- 17
0
votes
1 answer
Azure Table Storage - Save is working but retrieving data - can't get all fields in a record
I have the following class that represents a record in my storage table:
using Newtonsoft.Json;
using Azure.Data.Tables;
using System;
using Azure;
namespace MyProject.Models
{
public class ProvisioningRecord:ITableEntity
{
public string…
dot
- 14,928
- 41
- 110
- 218
0
votes
3 answers
How to read Azure table all rows in table entity
I have Azure table entity where I have queryResult with Partition Key, RowKey, Etag and Properties. I am trying to read Properties contains my table columns. But I am facing issue in reading the Properties using LINQ or tried to loop Properties and…
Mahee19
- 21
- 4
0
votes
1 answer
How to write combined query from azure table storage?
I am trying to query from a table so that the name and partition key (combined) unique.
I am doing this right now:
public Spec(string name)
{
Query = new TableQuery()
…
saon
- 591
- 1
- 7
- 19
0
votes
1 answer
How to filter boolean value in Azure Table Storage using OData filters?
I'm trying to filter Azure Table Storage using OData filters but for boolean values it always returns null results.
Here is list of filters that i've already tried:
IsBlocked eq {false}
IsBlocked eq '{false}'
IsBlocked eq 'false'
IsBlocked eq…
DiPix
- 5,755
- 15
- 61
- 108
0
votes
1 answer
Using Cosmos DB Table API to query for a datetime range
I am using Cosmos DB Table API to manage my data(Using SQL API is not an option). I have used "Creation DateTime Ticks" as the "PartitionKey". The idea is to retrieve data in every half an hour. To get the new data in half an hour range, I wrote a…
user1748546
- 97
- 2
- 11
0
votes
1 answer
How can I write a LINQ query towards a table in the Local Storage Account?
Desired flow:
HTTP Request to insert data into a table in azure storage. Currently using Postman and localhost. Note: This is running sucessfully and it is step 2 I'm struggeling with. <-- Azure Function
When data rows is stored in a table here…
Glenn Helgesen
- 11
- 2
0
votes
1 answer
Found operand types 'Edm.DateTime' and 'Edm.String' for operator kind 'GreaterThanOrEqual'
Getting an error while trying to get the entities from Azure Table on basis of Timestamp which is of type Edm.DateTime:
StorageError: A binary operator with incompatible types was detected. Found operand types 'Edm.DateTime' and 'Edm.String' for…
Piyush Kumar
- 169
- 1
- 9
0
votes
1 answer
Azure Table Storage: Is it possible to use a query condition that compares to result of adding two column values?
I have an Azure Storage table where I store the results of encounters with flashcards. It has columns like:
UserID
CardID
ConsecutiveCorrect
TotalCorrect
TotalIncorrect
Sadly, I did not think to add a column for TotalEncounters. I'm trying to think…
Brian Rak
- 4,912
- 6
- 34
- 44
0
votes
1 answer
What decides/controls number of returned records from Azure Table's ExecuteQuerySegmented(Async)'s?
What are the factors deciding how many records ExecuteQuerySegmentedAsync returns?
My scenario is that the number of returned records used to be ~500 and now it's ~35.
EDIT
My code is:
TableContinuationToken token = null;
do
{
…
tymtam
- 31,798
- 8
- 86
- 126
0
votes
1 answer
Azure Table Generics - Operation not supported on ExecuteQuery
I'm trying to create a generic implementation for Azure Tables. The ploblem is that when I use the ExecuteQuery function it always return the following error to me:
Error = Unable to evaluate the expression. Operation not supported.
Unknown error:…
Felipe Diniz
- 98
- 9
0
votes
1 answer
Azure Table Storage Update making columns as Null
I am using Azure Table Storage Rest Api to Update the entity.
If the entity has 5 columns(col1,col2,col3,col4,col5) and I am making a PUT request body something like this.
{"col1":"value"}
The rest of the columns value is set to NULL.
Is there a…
Rocket Singh
- 469
- 1
- 10
- 22
0
votes
1 answer
Performance comparison of Searching via String or Int64 for DateTime type with Azure Table
I need to search by DateTimeOffset type of local time on Azure Table.
My question is that if local time of DateTimeOffset type is saved as RowKey, which type is faster in indexing and searching by RowKey, String or Int64?
By Int64: DateTimeOffset…
Pingpong
- 7,681
- 21
- 83
- 209
0
votes
1 answer
how to find the hours between 2 dateTime in azure table storage using c#
I want find the number of hours in azure table storage
public UserTimeSheet GetTotalHoursByYear()
{
CloudTable cloudTable = GetCloudTable();
var query = new TableQuery()
{
SelectColumns =…
Niranjan S
- 132
- 9
0
votes
1 answer
Is There Any Method To Update Single Row Single Property in Azure Table?
Here is Problem In Detail
I have one Azure Table in which I have multiple rows in that table but my requirement is to update a single property on the basis of unique id which helps to find or get the records and update the related property
I tried…
Rahul Dhoundiyal
- 71
- 11