Get-AzureStorageTableRowByColumnName / Get-AzTableRow operators on Numeric Values about azurermstoragetable HOT 4 CLOSED

Hi @MCrank, thanks for the detailed informatio and you got it right in the last comment, the idea behind of custom filters is to allow usage of the other data types not covered by the -ColumnName parameter set. I will include your filtering example int the documentation together with another feedback I had so other people can benefit from it.

from azurermstoragetable.

@paulomarquesc

I have been running through some tests and think a couple of things have thrown me off. Using the Azure Storage Explorer when I look at my LSN values that I am saving as double they show up as string instead of double. Once I figured out that bug I was able to leverage a custom filter using GenerateFilterConditionForDouble which seems to be working. To test the theory I saved some as string and those were not returned. I am re-working my script now to make use of the new Az module so I can use the filter so that will take a little bit of time.

I'm going to leave this open so you can take a look. I think it would be a nice option to provide a way to filter on other datatypes without using the below. It works for sure. Just wanted to get your take. Hoping to get through this today/tomorrow. I'll post a follow up with more findings if needed.

[string]$Filter = [Microsoft.Azure.Cosmos.Table.TableQuery]::GenerateFilterConditionForDouble("LastLSNDbl",[Microsoft.Azure.Cosmos.Table.QueryComparisons]::"GreaterThan",109000002162400000)

from azurermstoragetable.

THANK YOU!
This has been absolutely driving me up the walls for the past couple of days! Any news on that detailed documentation, @paulomarquesc ?

from azurermstoragetable.

Hi @Sorensiim, at this link, you can find all supported filtering conditions, and you just use them the same way @MCrank posted. After you test it, please reply here with your code snippet so everyone can be helped as well since I'm going to reference this thread in the documentation.

from azurermstoragetable.