Current Position:Home > Af:table is not showing records until doing refresh of the view object iter

Af:table is not showing records until doing refresh of the view object iter

Update:11-30Source: network consolidation
Advertisement
Hi Experts,
I am using JDeveloper 11.1.1.4 and i have a page whhich shows records of a particular read only view object as an af:table. When i run the page at first it is not showing any data at all . But there are 2 records when i run the query of that read only view object.In my page there is a link called "Refresh" which calls the "Execute" operation of the view iterator of my view object. When i click this link the table shows two records.Why the table does not show records once wehn the page is rendered?
Please help me.

The Best Answer

Advertisement
The following is the code that shows the panel collection in my page.
<af:panelCollection id="pc1" featuresOff="freeze, wrap"styleClass="NewStyle">
<f:facet name="secondaryToolbar">
<af:toolbar id="t1" styleClass="Secondary">
*<af:query id="qryId1" headerText="Search" disclosed="false"*
*value="#{bindings.salesInvoiceAuthorisationCriteriaWaitOnlyQuery.queryDescriptor}"*
*model="#{bindings.salesInvoiceAuthorisationCriteriaWaitOnlyQuery.queryModel}"*
*queryListener="#{criteria.processQueryForSalesInvoice}"*
*queryOperationListener="#{bindings.salesInvoiceAuthorisationCriteriaWaitOnlyQuery.processQueryOperation}"*
*displayMode="compact"*
*saveQueryMode="readOnly" maxColumns="2"*
*modeChangeVisible="false" styleClass="Minimal"*
*conjunctionReadOnly="true"*
*resultComponentId="::t2"/>*
</af:toolbar>
</f:facet>
<af:table value="#{bindings.salesInvoiceAuthorisation1.collectionModel}"
var="row"
rows="#{bindings.salesInvoiceAuthorisation1.rangeSize}"
emptyText="#{bindings.salesInvoiceAuthorisation1.viewable ? 'No data to display.' : 'Access Denied.'}"
fetchSize="#{bindings.salesInvoiceAuthorisation1.rangeSize}"
rowBandingInterval="0"
filterModel="#{bindings.salesInvoiceAuthorisation1Query.queryDescriptor}"
queryListener="#{bindings.salesInvoiceAuthorisation1Query.processQuery}"
filterVisible="true" varStatus="vs"
selectedRowKeys="#{bindings.salesInvoiceAuthorisation1.collectionModel.selectedRow}"
selectionListener="#{bindings.salesInvoiceAuthorisation1.collectionModel.makeCurrent}"
rowSelection="none" id="t2"
columnStretching="column:accountNameColumn"
binding="#{processDocuments.invoiceTable}"
contentDelivery="immediate"
partialTriggers="::c111 selectToPost ::qryId1"
styleClass="newTableStyle" autoHeightRows="9">
<af:column filterable="false" sortable="false"
headerText="#{bindings.DocumentAuthorisationView1.hints.ToPost.label}"
id="c18" align="center"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
width="103">
<af:selectBooleanCheckbox id="selectToPost"
value="#{row.bindings.ToPost.inputValue}"
autoSubmit="true"/>
</af:column>
<af:column sortProperty="DocumentName" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.DocumentName.label}"
id="c11"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
width="107" filterFeatures="caseInsensitive">
<af:outputText value="#{row.DocumentName}" id="ot1"/>
</af:column>
<af:column sortProperty="ExternalReference" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.ExternalReference.label}"
id="c10"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
width="105" filterFeatures="caseInsensitive">
<af:outputText value="#{row.ExternalReference}" id="ot8"/>
</af:column>
<af:column sortProperty="DocumentCategory" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.DocumentCategory.label}"
id="c9"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
width="105" filterFeatures="caseInsensitive">
<af:outputText value="#{row.DocumentCategory}" id="ot11"/>
</af:column>
<af:column sortProperty="CrDr" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.CrDr.label}"
id="c4"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
width="52" align="right">
<af:outputText value="#{row.CrDr}" id="ot9">
<af:convertNumber groupingUsed="false"
pattern="#{bindings.salesInvoiceAuthorisation1.hints.CrDr.format}"/>
</af:outputText>
</af:column>
<af:column sortProperty="BaseDate" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.BaseDate.label}"
id="c8"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}">
<f:facet name="filter">
<af:inputDate value="#{vs.filterCriteria.BaseDate}"
id="id1" contentStyle="text-transform:uppercase;">
<af:convertDateTime pattern="#{bindings.salesInvoiceAuthorisation1.hints.BaseDate.format}"/>
</af:inputDate>
</f:facet>
<af:inputDate value="#{row.BaseDate}" id="ot6" contentStyle="text-transform:uppercase;">
<af:convertDateTime pattern="#{bindings.salesInvoiceAuthorisation1.hints.BaseDate.format}"/>
</af:inputDate>
</af:column>
<af:column sortProperty="ExternalAccountCode"
filterable="true" sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.ExternalAccountCode.label}"
id="c6"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
filterFeatures="caseInsensitive" visible="false">
<af:outputText value="#{row.ExternalAccountCode}" id="ot3"/>
</af:column>
<af:column sortProperty="AccountName" filterable="true"
sortable="true"
headerText="#{bindings.salesInvoiceAuthorisation1.hints.AccountName.label}"
id="accountNameColumn"
styleClass="#{row.bindings.ToPost.inputValue ? 'RowSelected' : ''}"
filterFeatures="caseInsensitive">
<af:outputText value="#{row.AccountName}" id="ot4"/>
</af:column>
</af:table>
</af:panelCollection>
Edited by: Priya on Nov 22, 2011 12:22 AM
  • Af:table is not showing records until doing refresh of the view object iter Update:11-30

    Hi Experts, I am using JDeveloper 11.1.1.4 and i have a page whhich shows records of a particular read only view object as an af:table. When i run the page at first it is not showing any data at all . But there are 2 records when i run the query of t

  • Issue with ADF Table bound to a View Object Iterator?? Update:10-11

    Can anyone say what would prevent an ADF table bound to a View Object Iterator from displaying all the records retrieved by the View Object Query? I ran the query directly from sqlplus and it returned 21 rows, However when i use the same exact query

  • Refresh table and display the records after insertion of data from back end Update:10-11

    Hi Experts, JDEV 11.1.2.1 I have a useacase which needs data to be inserted from oracle back end procedure and displayed in a ADF Table Component, when a button is pressed. is this possible?..if yes , how? Is view object will automatically refreshed

  • How to delete the Table Contents before inserting records into SQL table ? Update:10-11

    Hello Experts,         I have a scenario where in I have to Pick up some records from SAP RFC & insert into SQL table.         i know how to do this scenario but the proble with this is before inserting we first have to ZAP the SQL table & insert

  • Deleting records from a table with 12 million records Update:10-11

    We need to delete some records on this table. SQL> desc CDR_CLMS_ADMN.MDL_CLM_PMT_ENT_bak; Name Null? Type CLM_PMT_CHCK_NUM NOT NULL NUMBER(9) CLM_PMT_CHCK_ACCT NOT NULL VARCHAR2(5) CLM_PMT_PAYEE_POSTAL_EXT_CD VARCHAR2(4) CLM_PMT_CHCK_AMT NUMBER(9,2)

  • Creating an Excel file from table with 40,000 records Update:10-11

    I need help with creating an Excel file for client that has a table of 40,000 records. I have code that generates the Excel and has worked well in the past but with this much data it is timing out. I've already informed the client that Excel has limi

  • Internal Table with 22 Million Records Update:10-11

    Hello, I am faced with the problem of working with an internal table which has 22 million records and it keeps growing. The following code has been written in an APD. I have tried every possible way to optimize the coding using Sorted/Hashed Tables b

  • Delete 50 Million records from a table with 60 Million records Update:11-30

    Hi, I'm using oracle9.2.0.7 on win2k3 32bit. I need to delete 50M rows from a table that contains 60M records. This db was just passed on to me. I tried to use the delete statement but it takes too long. After reading the articles and forums, the bes

  • Refresh table automatically after adding record in dynpro Update:11-30

    I have a table element in my layout which is bind to a dictionary table and displaying the records correctly.I have input fields in the same view along with the add buttoon which inserts the entered record into the dictionary table successfully. Till

  • Insert a new record in the database table in between the records. Update:11-30

    i va a database table which ve 100 records. but i want to insert my new record  as 50th record. how i want to  proceed? thanks , velu.V, This is an odd request.  Why? Ignoring that, you can ATTEMPT to insert into the 50th position IF: 1) The DB table