| Order | Name | Type | Desc |
|---|---|---|---|
| 1 | haystack | pointlist | The point list to remove items from |
| 2 | needle | varies | The item to remove |
This searches the haystack list of points for the needle and removes it.
This function is used to remove results you don't want from your query. It's commonly used along-side functions like ALLPOINTS and AIPOINTS to remove properties or assets you aren't particularly interested in.
The needle parameter can be a list of assets, properties or points. All points that match will be removed.
If you had the following haystack point list…
| Haystack Content |
|---|
| Main Machine.Temperature |
| Main Machine.Status |
| Main Machine.Daily Total |
| Sub-Part.Vibration |
| Sub-Part.Temperature |
| Sub-Part.Daily Total |
The queries below would be useful…
'Daily Total' PROPERTY DROP
This would remove both of the 'Daily Total' properties.'
'Sub-Part' ASSET DROP
This would remove both Sub-Part properties.
'Sub-Part' ASSET 'Temperature' PROPERTY VALUES DROP
Would specifically remove the Sub-Part Temperature property, but leave the vibration property in place.