This is an old revision of the document!
DROP
Parameters
| Order | Name | Type | Desc |
|---|---|---|---|
| 1 | haystack | pointlist | The point list to remove items from |
| 2 | needle | varies | The item to remove |
Returns
This searches the haystack list of points for the needle and removes it.
Description
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.
Example
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 |
| Parent System.Speed |
The queries below would be useful…
'Daily Total' PROPERTY DROP
This would remove all points containing the 'Daily Total' property'
'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.