AnsweredAssumed Answered

Portal Filtering by Date Range and Name

Question asked by AdamQuintero on Apr 3, 2014
Latest reply on Apr 3, 2014 by AdamQuintero

Title

Portal Filtering by Date Range and Name

Post

     Greetings-

     I'm trying to filter a portal using a date range where the user selects the date from two global fields.  Also, I want to narrow that set with a text search on the "Name" field. I've been successful at both, but not at the same time. I think it's just a bit of logic that I'm missing.

     I'm using this filter for the dates(quoted from an older post by PhilModJunk):

"Tasks 2::Date_Start ≥ Tasks::g_StartDate

and

Tasks 2::Date_Start  ≤ Tasks::g_FinishDate"

I'm using this filter for the name:

PatternCount(Tasks 2::Name ; Tasks::g_Name ) > 0

or

Tasks::g_Name = ""

      
     In the combined filter, I did this:
      
"Tasks 2::Date_Start ≥ Tasks::g_StartDate
      
and
      
Tasks 2::Date_Start  ≤ Tasks::g_FinishDate"
      
and

PatternCount(Tasks 2::Name ; Tasks::g_Name ) > 0

or

Tasks::g_Name = ""

     What happens in the portal is nothing ever changes no matter what dates I put in, and either all records show (when nothing in Tasks::g_Name) or no records show (when anything in Tasks::gName). Is there a better or correct way to do this?

Outcomes