Is it possible to use! = In the query string?

Question

I am filtering the sharepoint list using the query string for some reason, I need to check a state like FieldValue! = Red, what can be achieved?

Or is it still a limitation?

.aspx FILTERNAME = EYHealthIndicator &? FilterMultiValue = red, yellow, and amp; & FilterField2 = Content Type &! FilterValue2 = Task

Answer 1

You cannot AFAIK.

A workaround could be to create a calculated column and then filter.

eg. create a Not-Red column with the formula

= IF ([YOUR_COLUMN_NAME] = "Red", "False", "True")

Then filter

?

FilterField1 = Not-Red & FilterValue2 = True

Answer 2

You can use Sharepoint Designer to filter a new, highlighted view of this list. You need: 1) queryString parameter how? FilteredNotValue! = Red 2) Add a filter to designer, operator = "Not Equal", value = new parameter → Name param = FilteredNotValue! → Parameter Source = QueryString. Completing a parameter name with "!" this is a trick, but it seems like it can do the job.