AnsweredAssumed Answered

Trouble with portal filtering

Question asked by jakhay on Oct 3, 2018
Latest reply on Oct 3, 2018 by philmodjunk

I have the following in a task management system:

(table)     (field)

selector

     id_currentJob     (global)

task

     id

     id_job

guideline

     id

     text

job

     id

     guidelinesList     (list of ids of guidelines associated with this job)

 

Relationships:

selector::id_currentJob -> job::id

 

I have a layout based on the "task" table. Using list view. In it (in a leading grand summary part), I have a portal based on the "guideline" table. I am trying to filter the portal to only show the guidelines that are in the job::guidelinesList field. Note that this layout only shows tasks from one job at a time, so all the found records have the same id_job value.

 

It kind of works, but to make it bulletproof, I had to add the following script step in my "refreshTaskLayout" script:

     set field [selector::id_currentJob ; selector::id_currentJob]

There has to be a better way...

 

I have tried the following, but ran out of time and could not get it to work...

I set up some new TOs (task_JOB based on job, and GUIDELINE_byjob_fromTask based on guideline) with the following relationships:

TASK::id_job -> task_JOB::id   and then   task_JOB::guidelinesList -> GUIDELINE_byjob_fromTask::id

 

And then based the portal on the GUIDELINE_byjob_fromTask TO... couldn't get it to work...

 

What is the filemaker way to do this?

Outcomes