Tessa
Member
Hi all,
I am having troubles trying to figure out when to use "OR and AND". I can simply figure out queries and where to use parenthesis playing around in phpMyAdmin but I'm unable to do this with the Menu Item Prefilters, And I need to make tons of these menu items.
I need it to say:
"WHERE approval == "Yes" <--- this must be returned no matter the results
AND Brand = 25 <-- volkl access level (parent is registered)
AND Brand = 26 <-- volkl access level
AND Brand = 1, 2, 3, 4, 5, 6 <--- K2 access level (parent is registered)
I've tried to mix and match , but it keeps not returning any results.
Am I doing this wrong?
Basically I am trying to show a custom page where all the approvals are Yes, and to separate 2 factories from being able to see each other's data (K2 and Volkl).
Thanks in advance,
Tessa
I am having troubles trying to figure out when to use "OR and AND". I can simply figure out queries and where to use parenthesis playing around in phpMyAdmin but I'm unable to do this with the Menu Item Prefilters, And I need to make tons of these menu items.
I need it to say:
"WHERE approval == "Yes" <--- this must be returned no matter the results
AND Brand = 25 <-- volkl access level (parent is registered)
AND Brand = 26 <-- volkl access level
AND Brand = 1, 2, 3, 4, 5, 6 <--- K2 access level (parent is registered)
I've tried to mix and match , but it keeps not returning any results.
Am I doing this wrong?
Basically I am trying to show a custom page where all the approvals are Yes, and to separate 2 factories from being able to see each other's data (K2 and Volkl).
Thanks in advance,
Tessa