IT_User

Filtered Portal based on Checkboxes

Discussion created by IT_User on Jul 29, 2013
Latest reply on Jul 31, 2013 by IT_User

So I've tried looking around, and I know this is probably an easy fix, but I just can't seem to get it.

 

I have two tables. One has a layout with a portal to the other table. I would like to filter it by using global fields I put into the first table.

 

I've tried the relationships of:

Table1::_kp_tableID = Table2::_kf_tableID

 

and then tried to use the portal filtering, by using an expression like

Table1::globalField1 = Table2::field2

 

Tried to Refresh Window (without flush cache)

 

Didn't work

 

So (removed the portal filtering) I tried to use table relationship like:

Table1::_kp_tableID = Table2::_kf_tableID

Table1::globalField1 = Table2::field2

 

Tried some combinations of:

Refresh Window (without flush cache)

and setting the ID field to itself on the first table

Usually set with script triggers of onObjectModify and OnObjectSave

and possibly Commit Records

 

Both globalField1 and field2 are checkboxes of 1 or nothing, and are number fields.

 

Any help is appreciated, thanks!

Outcomes