Hello all you Web ADI geeks

I seem to recall that a long time ago, when my dear old compadre Bob Morrans still had his own hair and teeth, the product known as ADE was configurable such that one could restrict the enterable values on a Standalone 'integrator' (or whatever it was called back then) to a particular parameter by use of an LoV, and that was underpinned by an LoV view.

I am most keen to know if that functionality survived to Web ADI, and if so does anyone have any documentation regarding the setting up thereof.

Thanks in advance

Clive,

Duno if I've answered my own question here but found this:

Step 4. Creating POPLIST for the required columns.
Now we are ready with the custom integrator, if we want to create POPLIST, User hint for any of the created integrator columns, use the following sql,

Create POPLIST for a column UNIT_OF_MEASURE
UPDATE bne_interface_cols_b
SET val_id_col = 'UNIT_OF_MEASURE',
val_mean_col = 'UNIT_OF_MEASURE',
val_type = 'TABLE',
lov_type = 'POPLIST',
val_obj_name = 'MTL_UNITS_OF_MEASURE_VL',
val_addl_w_c = 'DISABLE_DATE > sysdate or DISABLE_DATE is null'
WHERE interface_col_name = 'P_UNIT_OF_MEASURE'
AND application_id = lc_application_id_result
AND interface_code = lc_interface_code;
val_obj_name is the table name where the values should come from and val_addl_w_c is the where clause for the POPLIST restriction.

Check bne_integrator_utils for more details about creating LOV, Calender LOV and Chapter 5 of Web ADI Integrator Developer’s Guide for Java LOV.

In this article:

http://apps2fusion.com/at/61-kv/320-web-adi-custom-integrators

Do you think this is what we're looking for?

Thanks,

BC

Could well be it Bryan, good spot.