Logical value True-False misunderstood in a html file

[Radanca]

My PS array contains some logical values : True and False.
HTML file example :
"employeeid":"SRVCE",
"extensionAttribute8":"",
"userAccountControl":4260352,
"KerbDel":true,
"PWD never expires":false,
"enabled":true,

PSWriteHTML reads this items like as a parameter, not like as a value.
So, the html report doesn't work in Search Panes and Search Builder.
How to fix that ?

Thanks, your tool is great !

[PrzemyslawKlys]

Can you show some example (as a code) so I can replicate?

[Radanca]

$Users = @()
$User1 = [PSCustomObject]@{
    Name    = 'Kevin'
    Enabled = $true
}
$Users += $User1
$User2 = [PSCustomObject]@{
    Name    = 'Stella'
    Enabled = $false
}
$Users += $User2

$htmlfilepath = "$PSCRIPTROOT\Users.html"

New-HTML {
    New-HTMLTableOption -DataStore JavaScript
    New-HTMLTable -DataTable $Users -Title 'Table with Users' -HideFooter -PagingLength 25 -AlphabetSearch -Buttons searchPanes, searchBuilder, csvHtml5, excelHtml5, pdfHtml5, copyHtml5, pageLength
} -FilePath $htmlfilepath -Online -ShowHTML

The Search Builder doesn't work :
Add Condition
Condition = Enabled
Condition= Equals
Value = True

No result.

[PrzemyslawKlys]

There are two ways to deal with this:

1. Use HTML as DataStore (default)

$Users = @()
$User1 = [PSCustomObject]@{
    Name    = 'Kevin'
    Enabled = $true
}
$Users += $User1
$User2 = [PSCustomObject]@{
    Name    = 'Stella'
    Enabled = $false
}
$Users += $User2

$htmlfilepath = "$PSCRIPTROOT\Users.html"

New-HTML {
    #New-HTMLTableOption -DataStore JavaScript -BoolAsString
    New-HTMLTable -DataTable $Users -Title 'Table with Users' -HideFooter -PagingLength 25 -AlphabetSearch -Buttons searchPanes, searchBuilder, csvHtml5, excelHtml5, pdfHtml5, copyHtml5, pageLength
} -FilePath $htmlfilepath -Online -ShowHTML

2. Force BoolAsString for DataStore JavaScript

$Users = @()
$User1 = [PSCustomObject]@{
    Name    = 'Kevin'
    Enabled = $true
}
$Users += $User1
$User2 = [PSCustomObject]@{
    Name    = 'Stella'
    Enabled = $false
}
$Users += $User2

$htmlfilepath = "$PSCRIPTROOT\Users.html"

New-HTML {
    New-HTMLTableOption -DataStore JavaScript -BoolAsString
    New-HTMLTable -DataTable $Users -Title 'Table with Users' -HideFooter -PagingLength 25 -AlphabetSearch -Buttons searchPanes, searchBuilder, csvHtml5, excelHtml5, pdfHtml5, copyHtml5, pageLength
} -FilePath $htmlfilepath -Online -ShowHTML

SearchBuilder works with strings so I guess that's the issue with it. We could try opening an issue with DataTables SearchBuilder but I believe there's no need and workaround should work.

[PrzemyslawKlys]

Actually remember to not use += as it's a really expensive way to work with arrays.

$Users = @(
    [PSCustomObject]@{
        Name    = 'Kevin'
        Enabled = $true
    }
    [PSCustomObject]@{
        Name    = 'Stella'
        Enabled = $false
    }
)

$htmlfilepath = "$PSCRIPTROOT\Users.html"

New-HTML {
    New-HTMLTableOption -DataStore JavaScript -BoolAsString
    New-HTMLTable -DataTable $Users -Title 'Table with Users' -HideFooter -PagingLength 25 -AlphabetSearch -Buttons searchPanes, searchBuilder, csvHtml5, excelHtml5, pdfHtml5, copyHtml5, pageLength
} -FilePath $htmlfilepath -Online -ShowHTML

[Radanca]

That works.
Thanks a lot for the quick answer and the PS array tip.
Great job.