Altium Design Rule - Selecting Pads Whose Parent Component is not type "No BOM"
You can combine any series of rules to narrow down groups by using the keywords "AND", "AND NOT", "NOT", "OR", "OR NOT".

Like so: RuleOne AND RuleTwo --> Both need be true

If they are complex rules, put them in brackets: (RuleOne) AND (RuleTwo)

To be sure they get handled right.

You can test rules easily in the PCB Filter dialog (from the PCB button in the bottom right of your work area when in PCB mode and typing them there and see what gets left coloured. Everything that doesn't belong to things that comply with the filter you type will grey out, until you click "clear".

Loads of information is given in the Altium Design Rule Reference, but as is usual with the Altium Tech Docs, it's not the easiest to read.