1 2 Previous Next 16 Replies Latest reply on Aug 19, 2015 4:30 PM by electon

    Filter Portals

    mrosenhek

      I used to filter portals in older versions of FM by creating a relationship.

      For example a relationship to display all records in a portal within a date range as specified by 2 global field in the parent record; a start date and an end date that relate to a date field in the child records.

       

      With more recent versions of FM, I have been using the Portal Filter option which works great for many things, but I can't seem to construct the correct calculation for use with a date range. Perhaps it is not possible.

       

      This is my calculation in the Portal Filter dialog which is not working. It may be that I am not seeing the forest for the trees anymore.

       

      admin_TIME::Date ≥ ADMIN::f Payroll Start

       

      and

       

      admin_TIME::Date  ≤ ADMIN::f Payroll End

       

      So for example if I had a range of dates of portal records starting with Jan 1 and ending with Jan 30 BUT I wanted to see only Jan 1 to Jan 5;

      my global called f Payroll Start would be Jan 1

      my global called f Payroll End would be Jan 5

       

      Only those records should display but they are ALL still showing in the portal.

       

      Any advise? Thank you.

        1 2 Previous Next