9 Replies Latest reply: Nov 15, 2012 11:06 PM by Ranjith Chitharanjan RSS

    read only table not displaying data

    Tshifhiwa
      hi my read only table is not dispalying data when the page load,am in jdeveloper 11.1.1.6.0
      <af:query id="qryId1" headerText="Search" disclosed="true"
                            value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
                            model="#{bindings.ImplicitViewCriteriaQuery.queryModel}"
                            queryListener="#{bindings.ImplicitViewCriteriaQuery.processQuery}"
                            queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
                            partialTriggers="::t1"/>
                </af:panelHeader>
                <af:panelGroupLayout id="pgl1" halign="left" valign="middle"
                                     layout="vertical" inlineStyle="width:1806px;">
                  <af:table value="#{bindings.CfgTablesView1.collectionModel}"
                            var="row" rows="#{bindings.CfgTablesView1.rangeSize}"
                            emptyText="#{bindings.CfgTablesView1.viewable ? 'No data to display.' : 'Access Denied.'}"
                            fetchSize="#{bindings.CfgTablesView1.rangeSize}"
                            rowBandingInterval="0" id="t1" width="705"
                            inlineStyle="height:500px;">
                    <af:column sortProperty="Tablename" sortable="false"
                               headerText="#{bindings.CfgTablesView1.hints.Tablename.label}"
                               id="c1">
                      <af:outputText value="#{row.Tablename}" id="ot1"/>
                    </af:column>
                    <af:column sortProperty="Description" sortable="false"
                               headerText="#{bindings.CfgTablesView1.hints.Description.label}"
                               id="c2">
                      <af:outputText value="#{row.Description}" id="ot2"/>
                    </af:column>
                  </af:table>
      it show no data to display even if there is data in the database
      Edited by: adf0994 on 2012/11/15 9:43 AM

      Edited by: adf0994 on 2012/11/15 9:45 AM

      Edited by: adf0994 on 2012/11/15 10:02 AM

      Edited by: adf0994 on 2012/11/15 10:09 AM
        • 1. Re: read only table not displaying data
          user404
          Don't you see the table, or just don't see the data?
          • 2. Re: read only table not displaying data
            prateekazam
            It should show the data.There is no any hidden logic for read only table.For debugging purpose can run your AM and see the VO that is data is coming or not ?

            If no mean there is no data which table you are pointing currently.If yes just create a new pages and again try to drag and drop the table.


            Thanks

            Prateek
            • 3. Re: read only table not displaying data
              Tshifhiwa
              i don't see the data i have to click search and click refresh and then data display,am in jdeveloper 11.1.1.6.0,i what the page to load displaying data in database without clicking referesh,at the moment am not able to select or click on my parent read only table
              <af:query id="qryId1" headerText="Search" disclosed="true"
                                    value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
                                    model="#{bindings.ImplicitViewCriteriaQuery.queryModel}"
                                    queryListener="#{bindings.ImplicitViewCriteriaQuery.processQuery}"
                                    queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
                                    partialTriggers="::t1"/>
                        </af:panelHeader>
                        <af:panelGroupLayout id="pgl1" halign="left" valign="middle"
                                             layout="vertical" inlineStyle="width:1806px;">
                          <af:table value="#{bindings.CfgTablesView1.collectionModel}"
                                    var="row" rows="#{bindings.CfgTablesView1.rangeSize}"
                                    emptyText="#{bindings.CfgTablesView1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                    fetchSize="#{bindings.CfgTablesView1.rangeSize}"
                                    rowBandingInterval="0" id="t1" width="705"
                                    inlineStyle="height:500px;">
                            <af:column sortProperty="Tablename" sortable="false"
                                       headerText="#{bindings.CfgTablesView1.hints.Tablename.label}"
                                       id="c1">
                              <af:outputText value="#{row.Tablename}" id="ot1"/>
                            </af:column>
                            <af:column sortProperty="Description" sortable="false"
                                       headerText="#{bindings.CfgTablesView1.hints.Description.label}"
                                       id="c2">
                              <af:outputText value="#{row.Description}" id="ot2"/>
                            </af:column>
                          </af:table>
              Edited by: adf0994 on 2012/11/15 10:08 AM

              Edited by: adf0994 on 2012/11/15 10:10 AM

              Edited by: adf0994 on 2012/11/15 10:37 AM

              Edited by: adf0994 on 2012/11/15 11:05 AM
              • 4. Re: read only table not displaying data
                Arunkumar Ramamoorthy-Oracle
                User,

                Even after posting more than 1000 posts in this forum, you still don't provide the basic information.

                I would ask you to first go through this announcement : https://forums.oracle.com/forums/ann.jspa?annID=56 before posting any other thread.

                -Arun
                • 5. Re: read only table not displaying data
                  user404
                  So it shows data when you refresh your page?
                  • 6. Re: read only table not displaying data
                    Tshifhiwa
                    yes when i click refresh in my browser page i can see the data,i what when the page load display data,i don,t what to click referesh,and i what to dispaly child table based on parent read only table selection,another thing is before i click referesh i must click search button and than able to display data when clicking refresh

                    Edited by: adf0994 on 2012/11/15 11:30 AM
                    • 7. Re: read only table not displaying data
                      user404
                      Add a partial trigger to your child/detail table.
                      • 8. Re: read only table not displaying data
                        Tshifhiwa
                        ok i did that is working,but the problem is when the page load it does not display data,i have to click search button and on my query panel and click refersh than able to see data
                        <?xml version='1.0' encoding='UTF-8'?>
                        <jsp:root xmlns:jsp="http://java.sun.com/JSP/Page" version="2.1"
                                  xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
                                  xmlns:f="http://java.sun.com/jsf/core">
                          <af:panelHeader text="Maintain Schema" id="ph1"
                                          inlineStyle="height:853px; border-color:Lime; border-style:ridge;">
                            <f:facet name="context"/>
                            <f:facet name="menuBar"/>
                            <f:facet name="toolbar">
                              <af:outputLabel value="CF-L-017" id="ol1"/>
                            </f:facet>
                            <f:facet name="legend"/>
                            <f:facet name="info"/>
                            <af:panelStretchLayout id="psl1" inlineStyle="width:1869px; height:801px;"
                                                   bottomHeight="345px">
                              <f:facet name="bottom">
                                <af:panelGroupLayout layout="scroll"
                                                     xmlns:af="http://xmlns.oracle.com/adf/faces/rich"
                                                     id="pgl3" inlineStyle="width:1950px;">
                                  <af:panelStretchLayout id="psl2"
                                                         inlineStyle="width:1861px; height:376px;"
                                                         endWidth="4px">
                                    <f:facet name="center">
                                      <af:panelHeader text="Fields" id="ph6"
                                                      inlineStyle="height:500px; border-color:Lime; border-style:ridge;">
                                        <f:facet name="context"/>
                                        <f:facet name="menuBar"/>
                                        <f:facet name="toolbar"/>
                                        <f:facet name="legend"/>
                                        <f:facet name="info"/>
                                        <af:table value="#{bindings.CfgFieldsView1.collectionModel}"
                                                  var="row" rows="#{bindings.CfgFieldsView1.rangeSize}"
                                                  emptyText="#{bindings.CfgFieldsView1.viewable ? 'No data to display.' : 'Access Denied.'}"
                                                  fetchSize="#{bindings.CfgFieldsView1.rangeSize}"
                                                  rowBandingInterval="0"
                                                  selectedRowKeys="#{bindings.CfgFieldsView1.collectionModel.selectedRow}"
                                                  selectionListener="#{bindings.CfgFieldsView1.collectionModel.makeCurrent}"
                                                  rowSelection="single" id="t2"
                                                  partialTriggers="::cb2 ::cb5 ::cb6 ::cb4 ::cb3 ::t1"
                                                  inlineStyle="height:164px;" columnStretching="last"
                                                  width="918">
                                          <af:column sortProperty="Fieldlabel" sortable="true"
                                                     headerText="#{bindings.CfgFieldsView1.hints.Fieldlabel.label}"
                                                     id="c7">
                                            <af:outputText value="#{row.Fieldlabel}" id="ot4"/>
                                          </af:column>
                                          <af:column sortProperty="Format" sortable="true"
                                                     headerText="#{bindings.CfgFieldsView1.hints.Format.label}"
                                                     id="c4">
                                            <af:outputText value="#{row.Format}" id="ot7"/>
                                          </af:column>
                                          <af:column sortProperty="Type" sortable="true"
                                                     headerText="#{bindings.CfgFieldsView1.hints.Type.label}"
                                                     id="c3">
                                            <af:outputText value="#{row.Type}" id="ot6"/>
                                          </af:column>
                                          <af:column sortProperty="Length" sortable="true"
                                                     headerText="#{bindings.CfgFieldsView1.hints.Length.label}"
                                                     id="c6">
                                            <af:outputText value="#{row.Length}" id="ot3">
                                              <af:convertNumber groupingUsed="false"
                                                                pattern="#{bindings.CfgFieldsView1.hints.Length.format}"/>
                                            </af:outputText>
                                          </af:column>
                                          <af:column sortProperty="Fielddescription" sortable="true"
                                                     headerText="#{bindings.CfgFieldsView1.hints.Fielddescription.label}"
                                                     id="c5">
                                            <af:outputText value="#{row.Fielddescription}" id="ot5"/>
                                          </af:column>
                                        </af:table>
                                        <af:panelHeader text="Details" id="ph4"
                                                        inlineStyle="height:191px; border-style:ridge; border-color:Lime;">
                                          <f:facet name="context"/>
                                          <f:facet name="menuBar"/>
                                          <f:facet name="toolbar"/>
                                          <f:facet name="legend"/>
                                          <f:facet name="info"/>
                                          <af:panelFormLayout id="pfl1" maxColumns="2" rows="3"
                                                              partialTriggers="t1"
                                                              inlineStyle="width:589px;">
                                            <af:inputText value="#{bindings.Fieldlabel.inputValue}"
                                                          label="#{bindings.Fieldlabel.hints.label}"
                                                          required="#{bindings.Fieldlabel.hints.mandatory}"
                                                          columns="20"
                                                          maximumLength="#{bindings.Fieldlabel.hints.precision}"
                                                          shortDesc="#{bindings.Fieldlabel.hints.tooltip}"
                                                          id="it4">
                                              <f:validator binding="#{bindings.Fieldlabel.validator}"/>
                                            </af:inputText>
                                            <af:inputText value="#{bindings.Format.inputValue}"
                                                          label="#{bindings.Format.hints.label}"
                                                          required="#{bindings.Format.hints.mandatory}"
                                                          columns="20"
                                                          maximumLength="#{bindings.Format.hints.precision}"
                                                          shortDesc="#{bindings.Format.hints.tooltip}"
                                                          id="it3">
                                              <f:validator binding="#{bindings.Format.validator}"/>
                                            </af:inputText>
                                            <af:selectOneChoice value="#{bindings.Type.inputValue}"
                                                                label="#{bindings.Type.label}"
                                                                required="#{bindings.Type.hints.mandatory}"
                                                                shortDesc="#{bindings.Type.hints.tooltip}"
                                                                id="soc1">
                                              <f:selectItems value="#{bindings.Type.items}" id="si1"/>
                                            </af:selectOneChoice>
                                            <af:inputText value="#{bindings.Length.inputValue}"
                                                          label="#{bindings.Length.hints.label}"
                                                          required="#{bindings.Length.hints.mandatory}"
                                                          columns="20"
                                                          maximumLength="#{bindings.Length.hints.precision}"
                                                          shortDesc="#{bindings.Length.hints.tooltip}"
                                                          id="it2">
                                              <f:validator binding="#{bindings.Length.validator}"/>
                                              <af:convertNumber groupingUsed="false"
                                                                pattern="#{bindings.Length.format}"/>
                                            </af:inputText>
                                            <af:inputText value="#{bindings.Fielddescription.inputValue}"
                                                          label="#{bindings.Fielddescription.hints.label}"
                                                          required="#{bindings.Fielddescription.hints.mandatory}"
                                                          columns="20"
                                                          maximumLength="#{bindings.Fielddescription.hints.precision}"
                                                          shortDesc="#{bindings.Fielddescription.hints.tooltip}"
                                                          id="it1">
                                              <f:validator binding="#{bindings.Fielddescription.validator}"/>
                                            </af:inputText>
                                            <f:facet name="footer">
                                              <af:panelGroupLayout layout="vertical" id="pgl5">
                                                <af:panelGroupLayout layout="horizontal" id="pgl2">
                                                  <af:commandButton actionListener="#{bindings.First.execute}"
                                                                    text="First"
                                                                    partialSubmit="true" id="cb2"/>
                                                  <af:commandButton actionListener="#{bindings.CreateInsert.execute}"
                                                                    text="Add New"
                                                                    id="cb5"/>
                                                  <af:commandButton actionListener="#{bindings.Commit.execute}"
                                                                    text="Save"
                                                                    id="cb7"/>
                                                  <af:commandButton actionListener="#{bindings.Delete.execute}"
                                                                    text="Delete"
                                                                    id="cb6"/>
                                                  <af:commandButton actionListener="#{bindings.Next.execute}"
                                                                    text="Next"
                                                                    partialSubmit="true" id="cb4"/>
                                                  <af:commandButton actionListener="#{bindings.Last.execute}"
                                                                    text="Last"
                                                                    partialSubmit="true" id="cb3"/>
                                                </af:panelGroupLayout>
                                                <af:commandButton text="Submit" id="cb1"/>
                                              </af:panelGroupLayout>
                                            </f:facet>
                                          </af:panelFormLayout>
                                        </af:panelHeader>
                                      </af:panelHeader>
                                    </f:facet>
                                    <f:facet name="end"/>
                                  </af:panelStretchLayout>
                                </af:panelGroupLayout>
                              </f:facet>
                              <f:facet name="center">
                                <af:panelHeader text="Tables" id="ph2"
                                                inlineStyle="height:500px; border-color:Lime; border-style:ridge;">
                                  <f:facet name="context"/>
                                  <f:facet name="menuBar"/>
                                  <f:facet name="toolbar"/>
                                  <f:facet name="legend"/>
                                  <f:facet name="info"/>
                                  <af:panelHeader text="Filter" id="ph3"
                                                  inlineStyle="height:165px; border-style:ridge; border-color:Lime;">
                                    <f:facet name="context"/>
                                    <f:facet name="menuBar"/>
                                    <f:facet name="toolbar"/>
                                    <f:facet name="legend"/>
                                    <f:facet name="info"/>
                                    <af:query id="qryId1" headerText="Search" disclosed="true"
                                              value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
                                              model="#{bindings.ImplicitViewCriteriaQuery.queryModel}"
                                              queryListener="#{bindings.ImplicitViewCriteriaQuery.processQuery}"
                                              queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
                                              partialTriggers="::t1"/>
                                  </af:panelHeader>
                                  <af:panelGroupLayout id="pgl1" halign="left" valign="middle"
                                                       layout="vertical"
                                                       inlineStyle="width:1796px; height:298px;">
                                    <af:table value="#{bindings.CfgTablesView11.collectionModel}"
                                              var="row" rows="#{bindings.CfgTablesView11.rangeSize}"
                                              emptyText="#{bindings.CfgTablesView11.viewable ? 'No data to display.' : 'Access Denied.'}"
                                              fetchSize="#{bindings.CfgTablesView11.rangeSize}"
                                              rowBandingInterval="0" id="t1" width="833"
                                              inlineStyle="height:186px;" columnStretching="last"
                                              columnSelection="multiple"
                                              partialTriggers="::cb8 ::cb10 ::cb9"
                                              rowSelection="single"
                                              selectedRowKeys="#{bindings.CfgTablesView11.collectionModel.selectedRow}"
                                              selectionListener="#{bindings.CfgTablesView11.collectionModel.makeCurrent}">
                                      <af:column sortProperty="Tablename" sortable="true"
                                                 headerText="#{bindings.CfgTablesView11.hints.Tablename.label}"
                                                 id="c2">
                                        <af:outputText value="#{row.Tablename}" id="ot2"/>
                                      </af:column>
                                      <af:column sortProperty="Description" sortable="true"
                                                 headerText="#{bindings.CfgTablesView11.hints.Description.label}"
                                                 id="c1">
                                        <af:outputText value="#{row.Description}" id="ot1"/>
                                      </af:column>
                                    </af:table>
                                    <af:panelFormLayout id="pfl2" maxColumns="3" rows="1">
                                      <f:facet name="footer"/>
                                      <af:panelGroupLayout id="pgl6" layout="horizontal" valign="middle"
                                                           halign="right" inlineStyle="width:1228px;">
                                        <af:inputText value="#{bindings.Tablename.inputValue}"
                                                      label="#{bindings.Tablename.hints.label}"
                                                      required="#{bindings.Tablename.hints.mandatory}"
                                                      columns="#{bindings.Tablename.hints.displayWidth}"
                                                      maximumLength="#{bindings.Tablename.hints.precision}"
                                                      shortDesc="#{bindings.Tablename.hints.tooltip}"
                                                      id="it5">
                                          <f:validator binding="#{bindings.Tablename.validator}"/>
                                        </af:inputText>
                                        <af:inputText value="#{bindings.Description.inputValue}"
                                                      label="#{bindings.Description.hints.label}"
                                                      required="#{bindings.Description.hints.mandatory}"
                                                      columns="#{bindings.Description.hints.displayWidth}"
                                                      maximumLength="#{bindings.Description.hints.precision}"
                                                      shortDesc="#{bindings.Description.hints.tooltip}"
                                                      id="it6">
                                          <f:validator binding="#{bindings.Description.validator}"/>
                                        </af:inputText>
                                        <af:commandButton text="Add New" id="cb8"
                                                          actionListener="#{bindings.CreateInsert1.execute}"/>
                                        <af:commandButton actionListener="#{bindings.Commit.execute}"
                                                          text="Save" id="cb9"/>
                                        <af:commandButton actionListener="#{bindings.Delete1.execute}"
                                                          text="Delete" id="cb10"/>
                                      </af:panelGroupLayout>
                                    </af:panelFormLayout>
                                  </af:panelGroupLayout>
                                </af:panelHeader>
                              </f:facet>
                            </af:panelStretchLayout>
                          </af:panelHeader>
                        </jsp:root>
                        • 9. Re: read only table not displaying data
                          Ranjith Chitharanjan
                          Hi,
                           <af:query id="qryId1" headerText="Search" disclosed="true"
                                                value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
                                                model="#{bindings.ImplicitViewCriteriaQuery.queryModel}"
                                                queryListener="#{bindings.ImplicitViewCriteriaQuery.processQuery}"
                                                queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
                                                partialTriggers="::t1"/>
                          change it to
                           <af:query id="qryId1" headerText="Search" disclosed="true"
                                                value="#{bindings.ImplicitViewCriteriaQuery.queryDescriptor}"
                                                model="#{bindings.ImplicitViewCriteriaQuery.queryModel}"
                                                queryListener="#{bindings.ImplicitViewCriteriaQuery.processQuery}"
                                                queryOperationListener="#{bindings.ImplicitViewCriteriaQuery.processQueryOperation}"
                                                  resultComponentId="::t1"/>
                          instead of partial trigger set the resultComponentId in your query.



                          Ranjith