New-UDGrid with ServerSideProcessing - Sort Direction

BlairKingsley · February 14, 2019, 3:47pm

Anyone seen an issue when using New-UDGrid and ServerSideProcessing. The column sort is non-functional. The sort arrow seems to flick very briefly in the other direction, but changes back and the column doesn’t change sort direction. The value of $sortAscending in the debug output seems to remain the same.

I’m using this article for reference…

github.com

ironmansoftware/universal-dashboard/blob/master/examples/grid/high-performance-sql-grid.ps1

<#
    Provides an example of overriding the default filtering, sort and paging mechanism by querying SQL.
#>

Import-Module UniversalDashboard

$Dashboard = New-UDDashboard -Title "Grids - Simple" -Content {
    New-UDGrid -Title "Animals" -Headers @("Animal", "Order") -Properties @("Animal", "Order") -Endpoint {
        #Overrides filtering, sorting and paging. This ensures that SQL does the actions. 
        #All UDGrid endpioints have the following variables: 
        # - $sortAscending - Whether or not the sort is ascending
        # - $sortColumn - The name of the column to sort on 
        # - $filterText - The text to filter the data by
        # - $skip - The number of items to skip (used in paging)
        # - $take - The number of items to return (used in paging)

        $sortOrder = "DESC"
        if ($sortAscending ) {
            $sortOrder = "ASC"
        }

This file has been truncated. show original

Can anyone confirm they have this example with the column sorting working?

Thanks
BK

BlairKingsley · February 19, 2019, 10:34pm

Logged as issue #649. About to create pull request with probable fix.

Topic		Replies	Views
UDGrid issue when you filter the selection and more than one page of results Universal Dashboard Help	6	777	April 3, 2020
UDgrid and ServersideProcessing, but keep the client paging? Universal Dashboard Help	0	560	January 20, 2020
Table sort on dates is always ascending Universal Dashboard	1	202	November 11, 2023
Bug: UDTableColumn -DefaultSortColumn not working PowerShell Universal	7	454	May 20, 2021
How to best display a "large" table using Grid or other options? Universal Dashboard Help	5	1780	February 27, 2019

New-UDGrid with ServerSideProcessing - Sort Direction

Related topics