Command

New-TableCondition

Module: PSWriteHTML

Creates a new table condition with specified parameters and styling options for pass and fail conditions.

Syntax

New-TableCondition
[[-Alignment] <left|center|right|justify>]
[[-BackgroundColor] <String>]
[-CaseSensitive]
[[-ChildRowFill] <Parent|Both>]
[[-Color] <String>]
[[-ComparisonType] <number|string|bool|date>]
[[-DateTimeFormat] <String>]
[[-Direction] <rtl>]
[[-FailAlignment] <left|center|right|justify>]
[[-FailBackgroundColor] <String>]
[[-FailColor] <String>]
[[-FailDirection] <rtl>]
[[-FailFontFamily] <String>]
[[-FailFontSize] <Object>]
[[-FailFontStyle] <normal|italic|oblique>]
[[-FailFontVariant] <normal|small-caps>]
[[-FailFontWeight] <String>]
[[-FailTextDecoration] <line-through|overline|underline>]
[[-FailTextTransform] <uppercase|lowercase|capitalize>]
[[-FontFamily] <String>]
[[-FontSize] <Object>]
[[-FontStyle] <normal|italic|oblique>]
[[-FontVariant] <normal|small-caps>]
[[-FontWeight] <String>]
[[-HighlightHeaders] <String[]>]
[-Inline]
[-Name] <String>
[[-Operator] <String>]
[-ReverseCondition]
[-Row]
[[-TextDecoration] <line-through|overline|underline>]
[[-TextTransform] <uppercase|lowercase|capitalize>]
[[-Value] <Object>]
[<CommonParameters>]

Parameter set: All Parameter Sets

Description

This function creates a new table condition with the specified parameters and allows customization of the styling options for both pass and fail conditions.

Examples

Example 1

New-TableCondition -Name 'Policies_Go' -ComparisonType number -Operator le -Value 0.2 -Color SeaGreen -FailColor FireBrick

Uses a PowerShell numeric literal with a dot decimal separator.

Example 2

New-TableCondition -Name 'Policies_Go' -ComparisonType number -Operator le -Value '0,2' -Color SeaGreen -FailColor FireBrick

Uses a quoted locale-formatted decimal string. Avoid bare -Value 0,2 because PowerShell treats it as an array.

Parameters

-Alignment String optionalposition: 14: Specifies the alignment for pass conditions.; Possible values: left, center, right, justify
-BackgroundColor String optionalposition: 8: Specifies the background color for pass conditions.
-CaseSensitive SwitchParameter optional: Switch parameter to indicate if the comparison should be case-sensitive.
-ChildRowFill String optionalposition: 6: Child row fill for responsive lists; Possible values: Parent, Both
-Color String optionalposition: 7: Specifies the text color for pass conditions.
-ComparisonType String optionalposition: 2aliases: Type: Specifies the type of comparison to be performed. Valid values are 'number', 'string', 'bool', or 'date'.; Possible values: number, string, bool, date
-DateTimeFormat String optionalposition: 5: Specifies the format for date and time comparisons.
-Direction String optionalposition: 17: Specifies the text direction for pass conditions.; Possible values: rtl
-FailAlignment String optionalposition: 25: Specifies the alignment for fail conditions.; Possible values: left, center, right, justify
-FailBackgroundColor String optionalposition: 19: Specifies the background color for fail conditions.
-FailColor String optionalposition: 18: Specifies the text color for fail conditions.
-FailDirection String optionalposition: 28: Specifies the text direction for fail conditions.; Possible values: rtl
-FailFontFamily String optionalposition: 24: Specifies the font family for fail conditions.
-FailFontSize Object optionalposition: 20: Specifies the font size for fail conditions.
-FailFontStyle String optionalposition: 22: Specifies the font style for fail conditions.; Possible values: normal, italic, oblique
-FailFontVariant String optionalposition: 23: Specifies the font variant for fail conditions.; Possible values: normal, small-caps
-FailFontWeight String optionalposition: 21: Specifies the font weight for fail conditions.; Possible values: normal, bold, bolder, lighter, 100, 200, 300, 400, 500, 600, 700, 800, 900
-FailTextDecoration String optionalposition: 26: Specifies the text decoration for fail conditions.; Possible values: line-through, overline, underline
-FailTextTransform String optionalposition: 27: Specifies the text transformation for fail conditions.; Possible values: uppercase, lowercase, capitalize
-FontFamily String optionalposition: 13: Specifies the font family for pass conditions.
-FontSize Object optionalposition: 9: Specifies the font size for pass conditions.
-FontStyle String optionalposition: 11: Specifies the font style for pass conditions.; Possible values: normal, italic, oblique
-FontVariant String optionalposition: 12: Specifies the font variant for pass conditions.; Possible values: normal, small-caps
-FontWeight String optionalposition: 10: Specifies the font weight for pass conditions.; Possible values: normal, bold, bolder, lighter, 100, 200, 300, 400, 500, 600, 700, 800, 900
-HighlightHeaders String[] optionalposition: 1: Specifies an array of headers to highlight based on the condition.
-Inline SwitchParameter optional: Switch parameter to indicate if the styling should be applied inline.
-Name String requiredposition: 0aliases: ColumnName: Specifies the name of the condition.
-Operator String optionalposition: 3: Specifies the comparison operator to be used.; Possible values: lt, le, eq, ge, gt, ne, contains, like, notlike, notcontains, between, betweenInclusive, in, notin
-ReverseCondition SwitchParameter optional: Switch parameter to reverse the comparison logic.
-Row SwitchParameter optional: Switch parameter to indicate if the styling should be applied to the entire row.
-TextDecoration String optionalposition: 15: Specifies the text decoration for pass conditions.; Possible values: line-through, overline, underline
-TextTransform String optionalposition: 16: Specifies the text transformation for pass conditions.; Possible values: uppercase, lowercase, capitalize
-Value Object optionalposition: 4: Specifies the value to compare against. In PowerShell decimal literals use a dot, for example 0.2. If you want to pass locale-formatted text such as 0,2, quote it as a string. Bare 0,2 is parsed by PowerShell as an array containing 0 and 2 before PSWriteHTML receives it.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.