4 Replies Latest reply: Oct 15, 2012 5:57 AM by user467808 RSS

    Java Lov which has Multiple columns - LOV value selected is not populated

    user467808
      Hi Gurus,
      In my custom web ADI integrator, I have defined a new Java Validation Class and Component for a dependent field. This LOV displays 2 columns (Vendor Name and Vendor Site). This LOV displays these 2 values correctly for all resulted rows. But when any row is selected, the value is not returned to field in Spreadsheet.

      I didn't understand how to map the Lov Column (I want only one column - Vendor Site - value) into the interface column. If there is only one display name in LOV then we can set the tableSelect column to this interface column.

      My code is as below:
      String[] tableColumns = { "VENDOR_NAME", "VENDOR_SITE_CODE" };
      String[] tableHeaders = { "Vendor Name", "Vendor Site Code" };
      String[] *tableSelectColumn = { "P_VENDOR_SITE_CODE" };* // Where P_VENDOR_SITE_CODE is the interface column to where the select value has to return.

      -- and setting these values in as
      setTableData( getTableData( context.getBneWebAppsContext(), bean, parameterValues, searchCriteria ) );
      setTableColumns( tableColumns );
      setTableHeaders( tableHeaders );
      setTableSelectColumn( tableSelectColumn );


      My question here is:
      In tableColumns, I set 2 columns (VENDOR_NAME and VENDOR_SITE_CODE). In tableSelectColumn, I set only one interfaceColumn Name (P_VENDOR_SITE_CODE). How the integrator knows that which one out of 2 tableColumns map to single tableSelectColumn (P_VENDOR_SITE_CODE)?
      is it that when 'n' no. of columns are displayed in java lov then we must map them to 'n' no. of interface Columns (like, in my example, tableSelectColumn = {P_VENDOR_NAME, P_VENDOR_SITE_CODE} )?
      or
      java Lov doesn't support Multiple Columns to display?

      I found the code/answers only if one column displays in java-LOV. Please help me.


      Thanks in Advance

      Madhu
        • 1. Re: Java Lov which has Multiple columns - LOV value selected is not populated
          Ashish_Apps
          Never worked with JAVA LOV but plsql lov works fine.

          Same for AOL value sets
          • 2. Re: Java Lov which has Multiple columns - LOV value selected is not populated
            user467808
            Ashish,
            What is the solution for my issue in plsql lov. Could you elaborate more.


            Any other knows the solution in Java Lov. Please help me.

            Thanks
            Madhu
            • 3. Re: Java Lov which has Multiple columns - LOV value selected is not populated
              967532
              Hello Madhu,
              You have to set TABLE_COLUMN_ALIAS as well, because values in TABLE_COLUMNS and TABLE_SELECT_COLUMNS are not equal.I am saying values, not number of values.
              Go through below link for more information,
              http://sagarkatratoracleapps.blogspot.com/2012/09/DependentLOVOracleWebADI.html


              --
              Sagar
              • 4. Re: Java Lov which has Multiple columns - LOV value selected is not populated
                user467808
                Sagar,
                Thank You. It is working fine now.
                In Component class, I set the values as:

                String[] tableColumns = {  "VENDOR_SITE_CODE", "VENDOR_NAME" };
                String[] tableHeaders = { "Vendor Site Code", "Vendor Name" };
                String[] tableSelectColumn = { "P_VENDOR_SITE_CODE" };
                String[] tableColumnAlias = { "P_VENDOR_SITE_CODE", "VENDOR_NAME" };

                Thank You Once again Sagar.
                --Madhu