question - FILTER syntax for EDIT RESOURCE view

how should this filter be written? I can not fully understand the examples/samples provided in the Edit interface.

I have node names prefixed with "HQ" - "STATE" - "BRANCH".

I only want to see HQ and STATE in the Top XX - how do I filter out BRANCH?

I've tried Nodes.Caption in various forms but just haven't hit it just right...I'm obviously SQL illiterate.

Thanks,

Gil

Find more posts tagged with

filter

edit_resource

orion

Have you tried the following?

nodes.caption like 'hq%' and nodes.caption like 'state%'

that didn't work....but you did help me solve my problem...

this is what worked - I changed your AND to an OR...

Nodes.Caption LIKE 'HQ%' OR Nodes.Caption LIKE 'STATE%'

Thanks again