Filter queries define what is visible in a report view. The
filter query builder is where you define the filter. The filter
query builder is on a view's Filter tab.
You can use the following options:
Select attribute to filter by: Lists
attributes for the item you selected when you created the filter.
You cannot filter on values from a multi-contact control or table
control.
Scope: Lists relational operators. These
operators determine which description values for a certain
component will satisfy the query.
Display current values: Lists existing values
for the chosen inventory attribute. You can also manually enter an
appropriate value, or edit a selected value, with the Edit
values box. If the selected relational operator is Exists or
Not Exists, no description values are possible.
Logical operator: (displayed in a drop-down
list) Determines how query statements logically relate to each
other:
AND: Both the previous query statement AND the
statement to be inserted must be true to satisfy the query.
OR: Either the previous query statement OR the
statement to be inserted must be true to satisfy the query.
Insert: Inserts the new statement into the
query list and logically relates it to the other statements
according to the listed logical operator. You can't choose this
button until you've built an acceptable query statement.
Edit: Lets you
edit the selected query statement. When you're finished making
changes, click the Update button (which toggles between
Update and Insert).
Delete: Deletes the selected statement from
the query list.
Clear all: Deletes all statements from the
query list.
Query list: Lists each statement inserted into
the query and its logical relationship to the other listed
statements. Grouped statements are surrounded by parentheses.
Group (): Groups the selected statements
together so they're evaluated against each other before being
evaluated against other statements.
Ungroup: Ungroups the selected grouped
statements.
Querying on user-defined values
A powerful way to create report view filter queries is to allow
users to enter a user-defined value for the report query. When you
choose an attribute and operand, one of the available options in
the right pane is Insert a user-defined value.
When you click this option, you can choose to either run the
query based on the name of the user running the report or you can
prompt the user for a value. When prompting for a value, you can
also provide a prompt string that users will see when they run the
report that requests the value.
Once a user enters a value, the query runs using that value.
About the "Like" operator
Note that if a user doesn't specify any wild cards (*) in a
query, the Like operator adds wildcards (%) to both ends of the
string. Here are three examples of using the Like
operator:
Computer.Display Name LIKE "Bob's Machine" queries for:
Computer.Display Name LIKE "%Bob's Machine%"
Computer.Display Name LIKE "Bob's Machine*" queries for:
Computer.Display Name LIKE "Bob's Machine%"
Computer.Display Name LIKE "*Bob's Machine" queries for:
Computer.Display Name LIKE "%Bob's Machine"
500 Internal Server Error
Internal Server Error
The server encountered an internal error or
misconfiguration and was unable to complete
your request.
Please contact the server administrator at
webmaster@systemmanager.forsenergy.ru to inform them of the time this error occurred,
and the actions you performed just before this error.
More information about this error may be available
in the server error log.
Additionally, a 500 Internal Server Error
error was encountered while trying to use an ErrorDocument to handle the request.