Using "or" to filter CurrentUserID()

PHPMaker General Discussion (PHPMaker)
1

Hi everyone,

I’m trying to filter users based on a specific code in a field from my table. When I use the following filter code:

`student_profile_canonical_school_a_id` = " . CurrentUserID()

It works perfectly.

However, I now need to check against two more fields to match the CurrentUserID(). Here’s the filter I came up with:

`teacher_profile_canonical_school_a_id` = " . CurrentUserID() . " OR `teacher_profile_canonical_school_b_id` = " . CurrentUserID()

Unfortunately, this gives an error. Could anyone guide me to using the “or” statement filtering using the filter option in the tables listing filter option ?

I have three fields i need to filter by

teacher_profile_canonical_school_a_id
teacher_profile_canonical_school_b_id
teacher_profile_canonical_school_c_id

this would have been the normal MySQL to do the same

SELECT * 
FROM your_table_name*
WHERE teacher_profile_canonical_school_a_id = $CurrentUserID
   OR teacher_profile_canonical_school_b_id = $CurrentUserID
   OR teacher_profile_canonical_school_c_id = $CurrentUserID;

Thanks in advance!

2

Solved !!!

"(`teacher_profile_canonical_school_a_id` = " . CurrentUserID() . " OR 
  `teacher_profile_canonical_school_b_id` = " . CurrentUserID() . " OR 
  `teacher_profile_canonical_school_c_id` = " . CurrentUserID() . ")"