AnsweredAssumed Answered

Portal Filters complex?

Question asked by john.s on Mar 3, 2014
Latest reply on Mar 3, 2014 by john.s

Title

Portal Filters complex?

Post

     Hi,

     Grrr, I'm having trouble filtering a portal based on three conditions.

     I have the following relationships:

     Schools | Select Active ---< Schools ---<  Join_Schools_Jobs >---Jobs >--- JobType
                                                                                                                     >--- Sports
      
     Schools | Select Active:g_ActiveYes  to  Schools:ActiveStatus
     Schools:__pk_SchoolCode to Join_Schools_Jobs:_fk_SchoolCode
     Join_Schools_Jobs:_fk_JobID to Jobs:__pk_JobID
     Jobs:_fk_JobTypeID to JobType:__pk_JobTypeID
     Jobs:_fk_SportID to Sports:__pk_SportID
      
      
      
     Layout based on Schools with portal to self join Schools | Select Active table
         GoTo Related Records  two different portals based on Join_Schools_Jobs
            First Portal  on Join_School_Jobs I need to filter based on Calculation to determine current school year = Jobs:SchoolYearEnding and Sports:Season is either 1 or 4
     SchoolYearEnding field is not on Join_Schools_Jobs but is on the related Jobs table.  I can get the filter for the season being either 1 or 4 but not all three filters.
      
            Second Portal which shows candid jobs for the school is easier it just will be filtered by the same calculation for school year and Jobs:_fk_JobTypeID = 13
      
     I want to set this up so in the future we can search prior years jobs.
     Help will be greatly appreciated.
     John

Outcomes