Hi Experts,
I have a curious problem with a Web ADI LOV.
I have created a java LOV which brings back a simple list of Yes/No which I have attached to interface column COL2. I have also setup multiple reverse mappings so that COL2 Populates with "Yes" and COL1 populates with "Y" using the following ADI entries:
table-columns: VALUE,MEANING,DESCRIPTION
table-select-column: P_COL2,P_COL2X_B,P_COL1
table-column-alias: VALUE,MEANING,VALUE
(P_COL2) is hidden from the sheet. The mapped interface columns P_COL2X and P_COL1 are mapped to my content sheet and are displayed.
If I limit the list (e.g. use the search box and limit to a single result in the LOV) and select it my excel sheet populates correctly:
However, if I select the value when more than 1 value exists in the LOV window list, it selects the wrong value back to the COL1 value
example Before selection (We are selecting data for the second row here:
Select the Value Yes, from the LOV whilst there are multiple results in the LOV window and this happens:
(We are looking at row 2 here, which should have Y, Yes in it as it was displayed in the LOV. All we have done here using the LOV parameter mappings is tell it to return certain values from the LOV to the interface columns, I don't have any control over which row to send and assumed that ADI takes care of this its self so I'm not sure where to look to find the problem.
One value is correctly selected but the second value in the 1st column should be Y as it was displayed in the LOV. it seems like the first value is being returned from the LOV list regardless of which value i select.
Any help would be greatly appreciated.