How to sort table storage entries based on one column with DataType as DateTime

Hi

Please explain how to retrieve records from Azure Table Storage having different columns with different datatypes eg. String, DateTime, Int etc. and sort these records so that I can loop on those based on DateTime type col.

I am able to retrieve records from table using

New-Object System.Collections.Generic.List[string] to create an entity, but when I sort these based on DateTime Value,  I am not retrieiving in correct order. I guess this mistake is because I am putting values of table in list of type string.

Please help.

Regards

Robin

July 24th, 2015 1:38am

Use the PowerShell Sort-Object command to sort a table by date:

$entity | sort-object <datefieldname>

help sort-object -full

Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 3:21am

Hi jrv,

Please help me with $entity object. How are you creating\ getting this object.

I tried many things using same syntax, but din work. Because I am having $entity object as List[string] storing different col of on row. But different col have different data types.

Regards

Robin

July 24th, 2015 1:19pm

I thought you had a table?  If you query a table you get back an $entity.

I am sorry but we will not teach you incrementally how to use Azure. Please use your search engine and post inAzure forum for help inusing Azure.

Free Windows Admin Tool Kit Click here and download it now
July 24th, 2015 1:42pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics