Options for Filteroperator - New-UDDataGrid?

Product: PowerShell Universal
Version: 1.4.6

Hi,

is there an option for getting more Filter Operators?
2022-09-24
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 :wink:

Thanks

I‘ve opened an issue for that and Adam already closed it. It is coming with version 3.4

1 Like