The filtering options allow you to extend or limit the scope of information contained in the reports; so that you more efficiently can track down the information that you are looking for. Every time you apply the filter in a report, WATS will store the filter options and continue to use them through the current session.
See Also: Product Groups , Define your Virtual Manufacturing Levels
Apply filter
Store the filter for the session, run the report, and retrieve results that conform to the filter.
Clear filter
Replaces the current values set in the filter options with defaults.
Share filter
You can share your filter, eighter by e-mail or a link copied to the clipboard.
My filters
By clicking the button My filters, a menu showing your saved filters will appear to the right. Here you can access all your saved filters, add new ones and edit the ones available.
You can also manage the content of your saved filters from My Settings (upper right corner) -> Reporting Filters
Filter Options
The majority of the filter options support ranges and wild chars. A range can be specified by using @, eg 1@3 means 1 to 3 inclusive. If multiple values or ranges are specified, these must be separated by semicolon (;), eg 1@3; 5 means 1 to 3 (inclusive) and 5.
For a single character, the following syntax can be used:
- * or %: Zero or more characters
- ? or _: Any character at given position
- []: The character at given position must be within defined range and/or list of characters
- [^]: The character at given position must NOT be within range and/or list of characters
Eg:
- CAR%: All starting with or equal to CAR
- V_: All two-letter starting with V
- [0-9][0-9]: Two digits
- _[^0-9]: Two letters, the last not a digit.
- [0-9A-F][0-9A-F]: Two-digit hexadecimal number
When two or more filter options are specified, only test reports matching all the filter options are returned. If some of the filters do not have any reports in common, no data will be returned, as for instance if a product group is specified and a product which is not part of that product group.
The filters are applied to the specified run only. In other words, if you search for the second run on station A, the second run must have been run on test station A. The first run however, can have been run on any test station. In other words, second run on test station A does not mean the second time a unit is being tested on test station A.
PS! All searches are string searches, not numeric. A search for values 1 to 100 will thus include 1 and 10, but not 11 or 2 as the text strings 11 and 2 are greater than (sorted after) 100.
PPS! All searches are case insensitive; the letters A and a are considered equal.
Comments
4 comments
Is it possible to do a not equal search on items?
e.g. if I wanted to do a not equal to all serial numbers ending in "PSU" I tried !=*_PSU which didn't seem to work.
No, we don't have not equals search in the filter. We do have the Not-In Range ([^]), but you can't combine them together.
For example *_[^P][^S][^U] . It would not match 123ABU because the last letter is U.
Thank you Anders, I think this will be helpful. I wasn't sure on the conditions of that but I think this would be useful.
If I put in *[^P]__ would this find anything that doesn't contain P as the 3rd last letter?
Yes
Please sign in to leave a comment.