Filtering a dataset based on a specific attribute

How to Filter a dataset to show/not show certain features based on a specific attribute in QGIS

1. Right click on the relevant layer, and select Properties > Symbology > Rule-based
2. Give the query a name in the Label field
3. Click on the button to the right of the Filter field that looks like an E
4. Double click Fields and Values in the middle column
5. In the left column type NOT then double click the relevant field (ie. "DeviceName") then go back to the left column and type LIKE followed by the text that needs selecting (in this case Array) enclosed by ‘% %’ (the % character acts like a wildcard). It should appear as follows:
   NOT "DeviceName" LIKE '%Array%'
6. Click Apply and Close – a new symbology layer will now appear, showing only the features you’re interested in.
7. If you also want to just show the Array items, you can click on the + button towards the bottom of the window to add a new rule that could just show the array ones – ie. "DeviceName" LIKE '%Array%'
8. Tick/Untick the layers that you want to show on your map