4 Replies Latest reply on Jul 25, 2018 5:56 AM by user5108636

    Select list not showing display value

    user5108636
    user5108636 Jul 11, 2018 5:23 AM

      Hi All,

         Using APEX 5.1.3 with universal theme. I have an IR report with detail page. The detail page contains two select lists. The query for the IR page is based on a view. The detail page data fields are based on the same view and some additional tables.

      The additional tables data fields are populated from a PLSQL code on page load event which includes the select list fields. The select list is defined in shared components as

       

      select name as d,id as r

        from product

      order by 1

       

      The problem is on the UI it shows the return value instead of the display value.

       

      In the source properties of the select list item I have configured 'Type' is null.

       

      Please advise.

       

      Thanks

      • 63 Views
      • Tags:
        • 1. Re: Select list not showing display value
          fac586
          fac586 Jul 11, 2018 5:55 AM (in response to user5108636)

          user5108636 wrote:

           

          Hi All,

          Using APEX 5.1.3 with universal theme. I have an IR report with detail page. The detail page contains two select lists. The query for the IR page is based on a view. The detail page data fields are based on the same view and some additional tables.

          The additional tables data fields are populated from a PLSQL code on page load event which includes the select list fields. The select list is defined in shared components as

           

          select name as d,id as r

          from product

          order by 1

           

          The problem is on the UI it shows the return value instead of the display value.

           

          In the source properties of the select list item I have configured 'Type' is null.

          This typically happens when the select list Display Other Values property is set to Yes, and the item value does not exist in the defined LOV. Check that the value is a valid PRODUCT.ID.

          • 2. Re: Select list not showing display value
            user5108636
            user5108636 Jul 11, 2018 6:39 AM (in response to fac586)

            Hi Fac,

                Forgot to mention I have the read-only property on the select list based on another page item value.

             

            The issue seems to be caused by the read-only property. If I remove the read-only, gets displayed correctly.

             

            But my use case requires to show the form fields as read-only.

             

            Above suggestion based on Display Other Values does not apply in my case. i.e. the value passed to the select list is a valid one.

             

            Please advise.

            • 3. Re: Select list not showing display value
              Neil Clare
              Neil Clare Jul 11, 2018 8:17 AM (in response to user5108636)

              Rather than making the item read only, try giving it a CSS Class of apex_disabled (under Advanced)

              • 4. Re: Select list not showing display value
                user5108636
                user5108636 Jul 25, 2018 5:56 AM (in response to user5108636)

                Solution was to make it display only