Filter setting for duration and Spid etc (running queries) #1342
-
|
Is there a way to apply a filter like for duration/SPID/Query Text in running queries or slow queries tab. When we try the filter option, it seems to be looking for only Boolean value. |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
Hi, I think you might be using Edit Filter which requires a filter expression. e.g. I would use the highlighted filter options instead The Edit Filter option is useful if you need a more complex filter expression. You couldn't do something like this with the other options for example. Hope this helps |
Beta Was this translation helpful? Give feedback.
Hi, I think you might be using Edit Filter which requires a filter expression. e.g.
[session_id] = 33instead of just33I would use the highlighted filter options instead
The Edit Filter option is useful if you need a more complex filter expression. You couldn't do something like this with the other options for example.
([session_id] = 74 OR cpu_time>5). I use Filter By Value the most. It's rare that I need Edit Filter, but it's useful to have just in case.Hope this helps