AnsweredAssumed Answered

Portal Filters complex?

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


Portal Filters complex?



     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.