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
- !: Exclude filter value.
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
- ABC%;!ABCD: All starting with ABC, excluding ABCD.
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.
Date and time options
When selecting date and time range using the report filter date picker some options are available in certain reports to filter and group the data:
1. Show time as
This option allows the user to select whether or not to use local time or UTC time when querying data. Local time zone settings can be edited in My settings.
2. Period grouping
The applied time granularity where data is grouped by date and time.
3. Time as recurring
If this option is checked, data will be filtered according to from and to time as well as from and to date. I.E. from May 5, 2022 to Sep 7, 2023, between 09:00 and 17:00. Current time will apply if no time is specified.
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.