New-UDTable DateTimeFormat

PowerShell Universal
#1

Is seems the -DateTimeFormat is no longer valid with New-UDTable. In my V2 dashboard I have a function that returns data from a SQL query and the date is a SQL datetime I then reformat the datetime to a more readable format of Oct 25, 2020 5:00 AM. How is this done with the new New-UDTable.

Also I want to control the pages sizing using -PageSize and -PageSizeOptions but when I add them to the New-UDTable definition I get errors in the log and the page is blank
A parameter cannot be found that matches parameter name ‘PageSize’.
A parameter cannot be found that matches parameter name ‘PageSizeOptions’.

$Session:TotalPages = $Session:LastData.length

Code I am using

New-UDTable -Id ‘LastPatchData’ -Data $Session:LastData -Columns $Session:Columns -Sort -Filter -Search -Export -PageSize 20 -PageSizeOptions @(10, 20, 50)

#2

Are you using the 3.1.0 dashboard framework? You should have those paging options.

As for DateTimeFormat, we don’t have the at the moment. You’ll have to format in PowerShell which isn’t great because it won’t take the user’s browser timezone into account. I’ve added an item to the backlog to implement something in 1.5 for this.

#4

I am currently running 3.03, I upgraded to 1.4.2 this week, is there documentation on changing the Framework, I clicked around a bit but I did not see an obvious way of changing it. Do you just delete the Dashboard in the Admin and then import it again with the new framework?

As for the Datetime, Thank you, I have worked around it for now using Powershell to format the date but as you said it does not take the time zone into account.

#5

Sorry for not following up on this. As of 1.5, you can now set the framework to “Latest” which will always using the most recent framework rather than pinning to a specific version.

We added a Date and Time component to allow for client-side formatting: https://docs.ironmansoftware.com/dashboard/components/data-display/date-and-time