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!