...
| Info |
|---|
| One of the common challenges in building filters is how we think about what we want published and our use of the "AND" and "OR" words. For instance: "I want every device in Device Set A and Device Set B" entered as a filter would actually be processed as "I want every device that exists in both Device Set A and Device Set B". Instead we need to think of it as "I want every device that exists in Device Set A OR exists in Device Set B." |
Example 1: Publish data for every device that
...
begins with 'NGCTT' in Device Set D or is in Device Set A.
What works:
Using the "OR next filter" aggregate and an ‘*’ after ‘NGTT’ so ACM knows
to look in both folders, and a '*' after NGCTT so it searches for anything that starts with NGCTT, regardless the number of characters afterwardsthat objects to publish are:
- Found in the Device Set A folder OR
- Begin with ‘NGCTT’ and are found in Device Set D folder.
Example 2: Publish data for every device that
...
exists in Device Set D
...
and does not start with 'NGCTT' or exists in Device Set A.
What works:
- In this case, the filter is the same as example one Example 1 except the NGCTT* has moved into the "Not Name Text" field so that ACM rules it out.
...
In ACM, it is not possible to rule out an entire folder. Instead, we need to rule in all acceptable folders.
What works:
- Using the "OR next filter" aggregate to include each folder.
Example 4: Publish data for all devices that have both an "m" and a "y" OR are in Device Set A
Here we used What works:
- "AND next filter" on the first row to find devices containing both an "m" and a "y" and . On the third row, we use the "OR all previous filters" to mean that all of the previous filters must be considered as one.
Example 5: Publish data for all devices that have both an "m" and a "y" but do NOT have a "p"
Here we needed to "AND next filter" all three. Had we used "OR next filter before the record with the "P", it would have returned devices containing an "m" and a "y" and ALSO all devices that do not contain a "p" (whether or not they contain an "m" and a "y")
...