Client Automation Standard Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

OVCCM Reporting Filters and Special Characters

Highlighted
kkuc
Super Collector

OVCCM Reporting Filters and Special Characters

Has anyone tried to create logical combination of filters? I tried such a filter (it's undocumented feature):
@||
and it works OK, but when I try opposite:
@!&&!
I receive SQL Server syntax error.
Is it possible to create filter with 'AND' ?
3 REPLIES
Roy O Gatewood_
Honored Contributor

Re: OVCCM Reporting Filters and Special Characters

compound filters should work but you'd have to type it.
You may also apply multiple filters.
Page 57 of the RRS Guide talks to special characters.
kkuc
Super Collector

Re: OVCCM Reporting Filters and Special Characters

Thank's for reply. I know that I had to write compound filter, but how to do that? How to write or create filter wich excludes(removes) two records identified by the different values of the same column (Radia ID). In expamle, I've got devices, identified by Radia ID:
COMPUTER1
COMPUTER2
.
.
.
COMPUTER99
COMPUTER100

and want to show all devices except COMPUTER99 and COMPUTER100.

Roy O Gatewood_
Honored Contributor

Re: OVCCM Reporting Filters and Special Characters

Try a single exclusion first.
!RADIAID_1.
If that works then try the other one.
Operators are often database specific, consult their user manuals.
Have you tried direct sql queries?
Don't understand the use of || and then &&
//Add this to "OnDomLoad" event