Questions tagged [azure-tablequery]
126 questions
1
vote
1 answer
Azure Table Storage Filter Query
I am trying to filter rows against a String Type column. Basically I wanted to filter with part of string. It is very similar to LIKE operation in MySQL.
I have gone through this document…
HILARUDEEN S ALLAUDEEN
- 1,722
- 1
- 18
- 33
1
vote
1 answer
Azure Tables Retrieving/Casting Data Issue
Curious if someone could help me?
I do have an app that suppose to upload/download data to the table. No problem writing data to the table. Reading is the problem.
Here is what I have:
First is my Class:
Imports…
alex.s
- 17
- 7
1
vote
2 answers
Azure Table Storage - GUID coming back empty
I am trying to retrieve some entities from a table. I am successfully able to get back strings but when I try to get GUID, it comes back empty (all zeros).
[DataContract]
public class myEntity : TableEntity
{
[DataMember(Name = "ID")]
public…
Rotem Varon
- 1,597
- 1
- 15
- 32
1
vote
1 answer
query rowkey with greater than in azure table storage
I used this link and the quoted white paper to allow me to sort data inserted into table storage. The 'entities' stored have this simplified 'schema':
public class Bla : TableEntity
{
public Bla(){}
public Bla(string partitionKey)
{
…
cs0815
- 16,751
- 45
- 136
- 299
0
votes
0 answers
Unable to update a retrieved Azure storage table entity - "The specified resource does not exist"
I have some code which queries an Azure storage table, then returns a collection of results/entities.
These results/entities are then used in another method, and if a result in that method is false, update a property on the entity and then store it…
awj
- 7,482
- 10
- 66
- 120
0
votes
1 answer
Filtering the Data storage table using PartitionKey and Date time
I want to get the data over a time period using both PartitionKey and datetime filter.
https://sa.table.core.windows.net/ABC()?$filter=Timestamp%20gt%20datetime'2023-04-03T13:47:52.083669Z'andPartitionKey%20eq%20'123455432'
I have tried this query…
Prabhanjan
- 25
- 5
0
votes
1 answer
Struggling with syntax to mock Azure.Data.TableClient.Query()
I am trying to mock the Query method of Azure.Data.Tables.TableClient but cannot get my head around the syntax.
The concrete query I am trying to mock is:
var query = tableClient.Query(filter: mp => mp.PartitionKey == "abc");
My attempts to…
phil
- 1,938
- 4
- 23
- 33
0
votes
1 answer
Azure.Data.Tables QueryAsync filtering erring with multiple filter conditions
In the old SDK Azure Table you could create FilterConditions like the following
var partitionFilter = TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, symbolRoot);
var startDateFilter =
…
dinotom
- 4,990
- 16
- 71
- 139
0
votes
1 answer
Uppdate an entity in table storage
I have a script to update the entities in table storage (https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-how-to-use-powershell#updating-entities):
[string]$filter = `
…
user989988
- 3,006
- 7
- 44
- 91
0
votes
1 answer
Query Azure table storage for faster retrieval of data in C#
I have a ATS table whose Partition key and Row Key looks like:
PartitionKey RowKey
US_W|000000001 0000200325|0184921077191606273
US_W|000000004 0000200328|0184921077191606277
US_W|000000005 XXXXXXXXXX|XX(somenumbers)XXXX
To be…
Abhishek_Singh_Rana
- 65
- 4
0
votes
1 answer
Azure storage table: The remote server returned an error: (400) Bad Request when searching in a column
I am getting this error while executing this query against Azure table storage:
var query = table.CreateQuery()
.Where(d => d.PartitionKey == partitionId
&&…
Art
- 163
- 1
- 8
0
votes
0 answers
Optimize retrieving rows from Azure Table using partition key and row key with Range
Background:
I have a C# project where I need to retrieve records based on the partition key and row key with a range from an Azure Table (that has more than 5,00,000 rows with multiple partition keys and the row key is a timestamp when this row is…
skdev
- 1
0
votes
1 answer
Azure table storage: concurrent updates overwritting previous changes
I have an program that updates entries in an Azure Table Storage table like this:
recovers the entry from the table filtering by partitionKey and item Id
makes some changes in some properties of the recovered object.
saves changes back to…
Art
- 163
- 1
- 8
0
votes
0 answers
Azure Table Storage sync between 2 different storages
I have a list of storage accounts and I would like to copy the exact table content from source_table to destination_table exactly how it is. Which mean if I add an entry to source_table that will be moved to the destination_table same think if I…
Nayden Van
- 1,133
- 1
- 23
- 70
0
votes
0 answers
how to unit tests methods that contain calls to CreateQuery()
I got a method like this one:
public async Task> GetEntities()
{
var query = this.table.CreateQuery()
.Where(d => d.Properties[nameof(MyEntity.Fid)].GuidValue == Guid.Empty)
…
Art
- 163
- 1
- 8