3 Replies Latest reply: Jul 18, 2014 11:20 AM by Sky13 RSS

    Mobile Application Problem with Images In List View

    Sky13

      Hello,

      I am trying to create a "List View" using the "jQuery Mobile Smartphone" User Interface. The images do not show. I get two columns both showing the text value in the column defined as the "Text Column". I have the images stored in a table as blobs.  They are .png images 80x80 and display just fine under a test page I did using a classic report and the "Desktop" User Interface. I have also tried .jpg files. I also have tried all four options for "Image Type"

       

      The "List View" Region is defined as:

      Region Source:

       

      with DOTS as (

      select 12 as DOT_UID,'Item 1' as DOT_NAME,90 as GREEN,70 as YELLOW,70 as RED, 1 as CURRENT_DOT from dual

      union

      select 13,'Item 2',90,70,70,1 as CURRENT_DOT from dual

      union

      select 15,'Item 3',90,70,70,1 as CURRENT_DOT from dual

      union

      select 17,'Item 4',101,90,80, 3 as CURRENT_DOT from dual

      union

      select 22,'Item 5',95,85,85,1 as CURRENT_DOT from dual)

      select

          D.DOT_UID,

          D.DOT_NAME,

          D.GREEN,

          D.YELLOW,

          D.RED,

          D.CURRENT_DOT,

          I.IMAGE_UID,

          I.IMAGE_SMALL,

          dbms_lob.getlength("IMAGE_SMALL") as IMAGE_SMALL_2

      from

          DOTS D,

          SYNKDOT_IMAGE I

      where

          D.CURRENT_DOT = I.IMAGE_UID;

       

       

      Region Attributes:

      Settings

      Features

          Advanced Formatting = NULL

          Show Image = CHECKED

          Show List Divider = NULL

          Has Split Button = NULL

          Enable Search = NULL

          Is Nested List View = NULL

          Inset List = NULL

       

      Text Column = DOT_NAME

      Supplemental Information Column    = NULL

      Counter Column = NULL

      Image Type = Image stored in BLOB

      Image BLOB Column = IMAGE_SMALL

      Image Primary Key Column 1 = IMAGE_UID

      Image Primary Key Column 2

      Link Target = NULL

       

      I am running on:

       

      Application Express 4.2.1.00.08

       

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      CORE    11.2.0.3.0    Production

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      Viewing the "List View" on:

      FireFox 30.0

      iOS Safari

       

      Any help you can give me would be great. I have been researching and tiring many different this with no luck.  I hope it is something simple I am just not seeing.

       

      Message was edited by: Sky13.  I added information about image sizes and types tried.

        • 1. Re: Mobile Application Problem with Images In List View
          Patrick Wolf-Oracle

          Hi,

           

          have you tried using DOT_UID as Image Primary Key Column instead? The reason for that is that when we read the image we are executing the base SQL statement of the List View and restrict it with the Image PK column = current value of row. If you use IMAGE_UID and it isn't unique within that SQL statement you would be in trouble.

           

          BTW, I did a simple test before on DEMO_PRODUCT_INFO which contains a blob and it worked fine. Can you confirm that a simple test case also works for you?

           

          Regards

          Patrick


          Member of the APEX development team

          My Blog: http://www.inside-oracle-apex.com

          APEX Plug-Ins: http://apex.oracle.com/plugins

          Twitter: http://www.twitter.com/patrickwolf

          • 2. Re: Mobile Application Problem with Images In List View
            Sky13

            Hi Patrick,

            Thanks for looking at this with me.  I tried the DOT_UID and also a test using DEMO_RPODUCT_INFO and still did not get the image to show.

             

            with DOTS as (

            select 12 as DOT_UID,'Item 1' as DOT_NAME,90 as GREEN,70 as YELLOW,70 as RED, 1 as CURRENT_DOT from dual

            union

            select 13,'Item 2',90,70,70,1 as CURRENT_DOT from dual

            union

            select 15,'Item 3',90,70,70,1 as CURRENT_DOT from dual

            union

            select 17,'Item 4',101,90,80, 4 as CURRENT_DOT from dual

            union

            select 22,'Item 5',95,85,85,1 as CURRENT_DOT from dual)

            select

                D.DOT_UID,

                D.DOT_NAME,

                D.GREEN,

                D.YELLOW,

                D.RED,

                D.CURRENT_DOT,

                I.PRODUCT_ID,

                I.PRODUCT_IMAGE

             

            from

                DOTS D,

                DEMO_PRODUCT_INFO I

            where

                D.CURRENT_DOT = I.PRODUCT_ID;

             

             

            If I simply do this it works:

            select

                I.PRODUCT_ID,

                I.PRODUCT_NAME,

                I.PRODUCT_IMAGE

            from

                DEMO_PRODUCT_INFO

            • 3. Re: Mobile Application Problem with Images In List View
              Sky13

              I have logged an SR with Oracle Support and this is looking like a bug.  I will update this when I find out for anyone that is interested.