Mike27
June 16, 2021, 9:46pm
1
Hello,
I have a table that contains rows of alerts. Once acknowledged, I want the button to disappear, but this logic is not working:
New-UDTableColumn -Property acknowledge -Title "Acknowledge?" -Render {
if ($($EventData.ackBy) -eq '') {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server-Database monitor -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
}
} else {
New-UDButton -Text "$($EventData.ack)"
}
}
No matter what, the else statement always executes. I printed the information on the buttons to see what was displaying and it is showing blank for some or the name of the user who has acknowledged the button.
Product: PowerShell Universal
Version: 2.0.0
Mike27
June 17, 2021, 3:01pm
2
I updated with my section of the code instead of an example.
Thank you!!
Have you tried the following instead?
If ($($EventData.ackBy) -eq ‘’ -or $($EventData.ackBy) -eq $null)
1 Like
Mike27
June 17, 2021, 7:29pm
4
@jyoakum - I did try that and still falls to the else section. I am not sure what exactly is causing it. So for instance, if you look at my buttons, they are blank due to me populating it with that field which is currently empty. I am not sure if @adam can maybe shed some light on this. I just updated to 2.0.3 today to see if that resolves the issue.
The issue is with your script not the env, i would suggest testing your if statement to debug your issue the opposite way to see if it changes like
if ($($EventData.ackBy) -ne '') {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server-Database monitor -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
}
} else {
New-UDButton -Text "$($EventData.ack)"
}
}
and you can also try after that
if (-Not $($EventData.ackBy) ) {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server-Database monitor -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
}
} else {
New-UDButton -Text "$($EventData.ack)"
}
}
Mike27
June 19, 2021, 7:21pm
7
Still cannot get the button to go away. I tried using
if (-Not $($EventData.ackBy)) {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance serverx -Database monitoring -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
}
}
Causes the button to not appear at all regardless if there is data in ackBy field. Am I doing something wrong?
Mike27
June 19, 2021, 9:19pm
8
Also tried with this code:
New-UDTableColumn -Property acknowledge -Title "Acknowledge?" -Render {
if(-not($EventData.ackBy -eq $null -or $EventData.ackBy -eq "")) {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server -Database monitoring-Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
}
} else {
""
}
}
Mike27
June 24, 2021, 8:05pm
9
I am not sure if we are allowed to bump our post, but still having issues hiding the button.
adam
June 26, 2021, 2:14pm
10
You could try to hide the button using Set-UDElement.
New-UDTableColumn -Property acknowledge -Title "Acknowledge?" -Render {
if ($($EventData.ackBy) -eq '') {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server-Database monitor -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
Set-UDElement -Id "btn$($EventData.alertID)" -Properties @{ style = @{ display = "none" } }
}
} else {
New-UDButton -Text "$($EventData.ack)"
}
}
Mike27
June 30, 2021, 2:01pm
11
@adam , I tried that and it did not work. In my case, there is no acknowledged by and it ended up displaying a blank button.
if ($Roles -notcontains 'Monitoring') {
New-UDTableColumn -Property acknowledge -Title "Acknowledge?" -Render {
if ($($EventData.ackBy) -eq '') {
New-UDButton -Id "btn$($EventData.alertID)" -Text "Acknowledge Alert" -OnClick {
Show-UDToast -Message "Alert $($EventData.alertID) has been acknowledged"
Invoke-Sqlcmd -ServerInstance server
-Database Monitoring -Query "UPDATE tblAlerts SET acknowledged = 1, acknowledged_by = '$User', acknowledged_on = GETDATE() WHERE alertID = $($EventData.alertID)"
Set-UDElement -Id "btn$($EventData.alertID)" -Properties @{ style = @{ display = "none" } }
}
} else {
New-UDButton -Text "$($EventData.ack)"
}
}
}
I attached a screenshot. I am just not sure why it keeps falling to the else statement. I know I would want to put “” in the else when I do not want to display anything. At this time, I have it there to see what it is showing.
Mike27
June 30, 2021, 2:55pm
12
I was able to get this working by doing this:
New-UDTableColumn -Property acknowledge -Title "Acknowledge?" -Render {
if ([string]::IsNullOrEmpty($EventData.ackBy)) {
A post on stack overflowed explain this:
https://stackoverflow.com/questions/47128737/why-does-an-empty-powershell-hash-table-evaluate-to-true-when-an-empty-array-eva