Skip to Main Content
Forums

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ADF ListView - columns are been automatically hidden

Pedro CurtoAug 9 2016 — edited Aug 10 2016

Hello,

I'm using JDeveloper 12.2.1.

I have a problem with a listView when i use a panelGridLayout inside of it. The list is render but i only can see one row (the others are hidden or collapsed),

This is a sample code that this error occurs:

| Code example |
|

<?xml version='1.0' encoding='UTF-8'?>

<ui:composition xmlns:ui="http://java.sun.com/jsf/facelets"

            xmlns:af="[http://xmlns.oracle.com/adf/faces/rich](http://xmlns.oracle.com/adf/faces/rich)"

            xmlns:f="[http://java.sun.com/jsf/core](http://java.sun.com/jsf/core)">

<af:group id="g1">

 \<af:**listView** value="#{bindings.commentsVO1.collectionModel}"

              var="item"

              emptyText="#{bindings.commentsVO1.viewable ? 'No data to display.' : 'Access Denied.'}"

              fetchSize="#{bindings.commentsVO1.rangeSize}"

              id="lvCom"

              selection="single"

              selectionListener="#{bindings.commentsVO1.collectionModel.makeCurrent}">

  \<af:**listItem** id="li1">

    \<af:**panelGridLayout** id="pgl1">

      \<af:gridRow  height="auto"  id="gr1">

        \<af:gridCell id="gcComImage" marginStart="0px" marginEnd="10px" valign="middle" width="80px">

            \<af:**image** source="/resources/images/comment\_blue.png" id="i1"/>

        \</af:gridCell>

        \<af:gridCell id="gcCommnent" valign="middle" halign="start" width="30%">

            \<af:**outputFormatted** value="#{item.bindings.Text.inputValue}" id="of1"/>

        \</af:gridCell>

        \<af:gridCell id="gcImage" marginStart="0px" marginEnd="10px" valign="middle" width="80px">

           \<af:**image** source="/resources/images/comment\_blue2.png" id="i2"/>

        \</af:gridCell>

        \<af:gridCell id="gcPostedBy"  valign="middle" halign="center" width="10%">

                 \<af:**outputFormatted** value="{item.bindings.UpdatedByName.inputValue}" id="of1"/>

        \</af:gridCell>

      \</af:gridRow>

    \</af:panelGridLayout>

  \</af:listItem>

\</af:listView>

</af:group>

</ui:composition>

|

This is the result:

| Result |
| pastedImage_8.png |

Anyone already have face this ADF listView behavior?

Any help will be aprreciated.

Regards,

Pedro Curto

Comments

Barry B

Sorry, we're on Apex 18
Oracle database is 12

AndyH

In APEX you should probably be referring to the 'APP_USER' variable to get the name of the user running your application e.g.

select v('APP_USER') from dual;
select sys_context('APEX$SESSION','APP_USER') from dual;

This assumes that your users have to authenticate to use the page, otherwise, you use will always be app_user 'nobody' and 'APEX_PUBLIC_USER' if you refer to 'USER'.
I'm not sure why you are seeing the 'ANONYMOUS' user: that's usually associated with XDB. I assume that you're not using the Embedded PL/SQL Gateway to access your application?

Barry B

Hi,

I agree. Unfortunately over a hundred reports have been created before my time using the USER variable.
This ANONYMOUS user is then configured on a custom table to produce a local language. It is what it is...
Unfortunately that logic doesn't work when the interactive reports are subscribed to.
So I was wondering how/where ths SYS value comes from, and whether there is any database or Apex setting that we could change to turn the "USER" variable from SYS into ANONYMOUS (i.e the same behaviour as we get on the application).

Barry

AndyH

You can change USER - it's 'owned' by Oracle.
If you are seeing 'SYS' when you query USER e.g.

select user from dual

then you have a very strange setup.
However, if 'SYS' is a username in your application e.g. you have some form of custom authentication then you'll need to investigate from that side.

Barry B 
select user from dual

Equal SYS: This is what is happening on the subscription. I was wondering where that is set.
Equals ANONYMOUS from Apex. I don't know where that is set, but it doesn't matter anyway.
Ideally we would like it to be ANONYMOUS for both. This is what I'm asking, sorry for not being clear.

AndyH

Presumably, you've not installed your application within the SYS schema? That would be very bad.
You cannot change the value returned by USER.

Barry B

if you "select user from dual" in apex as an interactive report, what do you get?
If you subscribe to it , what do you get?

1 - 7
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 7 2016
Added on Aug 9 2016
#adf, #application-development-in-java, #jdeveloper-and-adf, #problem
2 comments
151 views