Product: PowerShell Universal
Version: 1.4.6
Hi,
is there an option for getting more Filter Operators?
I like to have NOT contains and NOT equals.
I have build that for me like:
switch ($item.operatorValue) {
"contains" {
if ($Value -like "!*"){
$Val = $Value.TrimStart("!")
$SqlFilter += "[$Property] NOT LIKE '%$($Val.replace($BadChar,''))%' AND "
}
else {
$SqlFilter += "[$Property] LIKE '%$($Value.replace($BadChar,''))%' AND "
}
}
"equals" {
if ($Value -like "!*"){
$Val = $Value.TrimStart("!")
$SqlFilter += "[$Property] != '$($Val.replace($BadChar,''))' AND "
}
else {
$SqlFilter += "[$Property] = '$($Value.replace($BadChar,''))' AND "
}
}
but thats not quite good
Thanks