| external help file | Module Name | online version | schema |
|---|---|---|---|
AzureRmStorageTableCoreHelper-help.xml |
azurermstoragetable |
2.0.0 |
Returns one or more rows/entities based on custom Filter.
Get-AzTableRowByCustomFilter [-Table] <Object> [-CustomFilter] <String> [[-Top] <Int32>] [<CommonParameters>]Returns one or more rows/entities based on custom Filter. This custom Filter can be built using the Microsoft.Azure.Cosmos.Table.TableQuery class or direct text.
# Getting row by firstname by using the class Microsoft.Azure.Cosmos.Table.TableQuery
$MyFilter = "(firstName eq 'User1')"
Get-AzTableRowByCustomFilter -Table $Table -CustomFilter $MyFilter# Getting row by firstname by using text Filter directly (oData Filter format)
Get-AzTableRowByCustomFilter -Table $Table -CustomFilter "(firstName eq 'User1') and (lastName eq 'LastName1')"# Getting row by firstname with a maximum number of rows returned
Get-AzTableRowByColumnName -Table $Table -ColumnName "firstName" -value "Paulo" -Operator Equal -Top 10Table object of type Microsoft.Azure.Cosmos.Table.CloudTable to retrieve entities
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseCustom Filter string.
Type: String
Parameter Sets: (All)
Aliases:
Required: True
Position: 2
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseReturn only the first n rows from the query
Type: Int32
Parameter Sets: (All)
Aliases:
Required: False
Position: 3
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThis cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).