none
Funny Filter RRS feed

  • Question

  • I am wondering what I am doing wrong when I write a filter under manage views that says:

    Project Department CONTAINS Engineering

    (where Project Department is a defined custom field, and there are defined departments called Engineering Structural, Engineering Mechanical, and Engineering Electrical).

    If you specify:

    Project Department EQUALS Engineering Structural               IT WORKS

    If you specify:

    Project Department DOES NOT EQUAL Engineering Structural        IT WORKS

    I tried it with "  or ' and it never works for CONTAINS, or STARTS WITH.

    What am I missing?

    Wednesday, May 13, 2015 6:18 PM

All replies

  • In other contexts outside of project, 'Contains' I think looks at the whole string/element. It's probably the same here. Something along the lines of 'matches' or 'like' should do it for you if those are options... although I'm surprised 'Starts with' didn't work.

    Ian

    Wednesday, May 13, 2015 9:32 PM