none
PWA 2007, Filtering Project Center views RRS feed

  • Question

  • Hi,

    I need to apply this filter to a project center view:

    (stage = planned or stage = active) and (category = A or category = B)

    "stage" and "category" are custom fields

    I add this filter to the view:

    stage equals planned or

    stage equals active and

    category equals A or

    category equals B

     

    but I still see projects in the view that don´t fullfill both conditions (stage and category)

    Is there any way to apply both category and stage conditions to the filters?

    Thanks, Patricia

     

    Thursday, June 24, 2010 8:03 PM

Answers

  • Thanks Andrew, I tried but it didn't work, the view doesn't show some category B and planned projects. :-(

    I tried another way... I created two new custom fields with formulas:

    stageFilter: "yes" if stage = planned or stage = active

    categoryFilter: "yes" if category = A or category = B

    and then I changed the view filter: stageFilter = yes and categoryFilter = yes

    I think perhaps it's not the best, but it worked

     

    Patricia

     

    Friday, June 25, 2010 6:39 PM

All replies

  • Working without Project Center in front of me....you may have to try:
     
    Stage equals planned AND category equals A OR
    Stage equals planned AND Category equals B OR
    Stage equals Active AND Category equals A OR
    Stage equals Active AND Category equals B
     
    A bit tedious, but doable.
     
    - Andrew Lavinsky
     
    > stage equals planned or
    > stage equals active and
    > category equals A or
    > category equals B
     
     
    Thursday, June 24, 2010 9:13 PM
    Moderator
  • Thanks Andrew, I tried but it didn't work, the view doesn't show some category B and planned projects. :-(

    I tried another way... I created two new custom fields with formulas:

    stageFilter: "yes" if stage = planned or stage = active

    categoryFilter: "yes" if category = A or category = B

    and then I changed the view filter: stageFilter = yes and categoryFilter = yes

    I think perhaps it's not the best, but it worked

     

    Patricia

     

    Friday, June 25, 2010 6:39 PM