Additional options
You can use the following additional options with the export option.
| Option | Description |
|---|---|
-filter |
Filter the results of the export command |
-filterRule |
Broaden your filtering capabilities by entering a string against which results are compared to find matches. The syntax of the filter string is similar to the syntax of an SQL WHERE clause, so that you can filter on common SQL keywords such as OR, AND, LIKE, IN, and so forth. |
-order |
List columns in order |
-distinct |
Eliminate duplicate lines |
-ListForced |
Force columns to display values |
Using -filter
The following option lets filter the results of the export command.
-filter
List of filtered values "colname(value) ..", same syntax
as -colNames. Lets you filter the results of a command.
The
following table lists available -filter values:
| Values | Examples |
|---|---|
| is null, not null | name(is null) name(not null) |
| Any character with * (like operator is used) | name(*ddd*) |
| Any character (= operator is used) | name(ddddd) |
Relational operator (in,between,!=,>,<,..) 'any character' AND is made between filters |
name(!='ddd') number(<='10') name(in'ddd','aaa','bbb') between('0 and 3') |
resmgr -export elt -colNames "name profil state missing" -filter
"missing(between'0 and 3') name_UPPER(*BOST*)"
bulk100-boston_1000,18|_|bulk_100|_|on|_|0|_|
bulk100-boston_100,11|_|bulk_100|_|on|_|0|_|
bulk100-boston_1000,19|_|bulk_100|_|on|_|0|_|