In the aforementioned section of InformixHQ I can look for sessions owned by user "joe". I can do the same with onstat -g ses | grep joe. But in that same grep command I can also say: onstat -g ses | grep -v informix if I want to see all but informix sessions.

What is the syntax for negating a username - like informix - in InformixHQ?  I wanted see all sessions but those of informix.

Thanks, on behalf of myself and my colleague, who is as befuddled as I am over this. ;-)

------------------------------
+-----------------------------------------------------------+
| I am pleased to report that I had no problems today. |
| I had only issues, opportunities, challenges and valuable |
| learning experiences. |
+------------------------------------------ Jacob S --------+
------------------------------

Hi Jacob,

the "Search" option offered by those reports apparently isn't the same as a full fledged filter option, ideally by column ...

I quickly drafted an internal story to implement some useful filtering, but it shouldn't hurt to also have an AHA item (feature request) where you, and others, could specify what kind of functionality you'd like to see there.

HTH,
 Andreas

------------------------------
Andreas Legner
Informix Dev
HCL Software
------------------------------

Thanks for posting the URL for the feature request facility.  AHA?  As I commented in the FR I just submitted, I don't say AHA! until I hit on a solution. ;-) 

[INFX-I-688] 

Better search facility for filters in Informix-HQ. Like a negation NOT operator.

------------------------------
+-----------------------------------------------------------+
| I am pleased to report that I had no problems today. |
| I had only issues, opportunities, challenges and valuable |
| learning experiences. |
+------------------------------------------ Jacob S --------+
------------------------------

Original Message:
Sent: Thu November 06, 2025 08:36 AM
From: Andreas Legner
Subject: InformixHQ: In Performance/Sessions section: filter by "NOT informix"

Hi Jacob,

the "Search" option offered by those reports apparently isn't the same as a full fledged filter option, ideally by column ...

I quickly drafted an internal story to implement some useful filtering, but it shouldn't hurt to also have an AHA item (feature request) where you, and others, could specify what kind of functionality you'd like to see there.

HTH,
 Andreas

------------------------------
Andreas Legner
Informix Dev
HCL Software
------------------------------