jdesmm
Well Known Member
We have an application that we'd like to be able to filter by multiple instances of the same field. For instance, we'd like to be able to include multiple branch plants in the grid data returned:
I've set up the find/browse form header as:
Branch Plant 1 [______]
Branch Plant 2 [______]
Branch Plant 3 [______]
Obviously, to use default filtering, you can only add one instance of a business view column, i.e BC Business Unit. So I began looking into the Set Selection system function. However, I can't get it to do anything!
I added three MCU data dictionary fields to the form header as you see in the layout above. I then tried creating the Set Selection statement. Specifically, I did a Clear Selection, then Set Selection Append Flag = "Yes", then the Set Selection statement itself. One thing I was confused about was the Table parameter. It's not clear to me from the JDE documentation what that one should be. I set it to the BC Business Unit column and then set the Alias parameter to the GC Business Unit column, but I'm not sure at all that I'm on the right track. My comparison is to the FC DD Business Unit field and the type is OR. I basically perform the Set Selection 3 times, for each FC field. I've tried placing the code both in the FC Exit & Changed Asycn and the Find Button - Button Clicked ER with no errors but no successful results.
Can anyone give me an example of how to successfully do what I'm trying to do, or is there some reason it can't be done?
Thanks!
--Shelley M. Maas
--Apio, Inc.
*----------------------*
* Shelley M. Maas *
* Development Manager *
* Apio, Inc. *
*----------------------*
I've set up the find/browse form header as:
Branch Plant 1 [______]
Branch Plant 2 [______]
Branch Plant 3 [______]
Obviously, to use default filtering, you can only add one instance of a business view column, i.e BC Business Unit. So I began looking into the Set Selection system function. However, I can't get it to do anything!
I added three MCU data dictionary fields to the form header as you see in the layout above. I then tried creating the Set Selection statement. Specifically, I did a Clear Selection, then Set Selection Append Flag = "Yes", then the Set Selection statement itself. One thing I was confused about was the Table parameter. It's not clear to me from the JDE documentation what that one should be. I set it to the BC Business Unit column and then set the Alias parameter to the GC Business Unit column, but I'm not sure at all that I'm on the right track. My comparison is to the FC DD Business Unit field and the type is OR. I basically perform the Set Selection 3 times, for each FC field. I've tried placing the code both in the FC Exit & Changed Asycn and the Find Button - Button Clicked ER with no errors but no successful results.
Can anyone give me an example of how to successfully do what I'm trying to do, or is there some reason it can't be done?
Thanks!
--Shelley M. Maas
--Apio, Inc.
*----------------------*
* Shelley M. Maas *
* Development Manager *
* Apio, Inc. *
*----------------------*