2. PHPRunner General questions
  3. Dependent Dropdown using binary operators
This topic is locked

Dependent Dropdown using binary operators

 		3/24/2014 9:47:45 AM
PHPRunner General questions
K
 kplunkert author

Been using PhpRunner for years and now I am stumped.
I need to use the lookup wizard for a dropdown box.
The dropdown box is dependent on AreaID. The part I am stuck on is that I need to use a binary operator to generate the list
if menumask & areaid = true it displays in the dropdown.
Does anyone have any ideas.
Thanks
Karl Plunkert
Sergey Kornilov admin 3/25/2014

Karl,
you need to elaborate. It's not clear if you are talking about hiding the whole dropdown control or hiding some items in dropdown control.
K
 		kplunkert author 3/25/2014

Okay, thank you for responding.
AreaID is a drop downlist it contains display {Customer Service, Order Management, Inventory Management) these map to the values 1,2,4 respectively. (powers of two that correspond to a bit)
The TaskList has a field MenuMask, this has an integer value a value of 1 the item will show when Customer Service is selected in the AreaID field. If the menu mask is 5 (1+4) the menu item will show when Customer Service or Inventory Management is selected.
if you use a bitwise and between tasklist and the areaid selected you will get the drops downs defined for that area.
Does that help?
if I could use the values["AreaID") & MenuMask in the where clause, I would be done> When I try, the sql comes back blank for AreadID.
Sergey Kornilov admin 3/25/2014

Sorry, this doesn't help.