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!

exportCollectionActionListener gives errror when selectBooleanCheckbox in column

KdeGraafJun 3 2019 — edited Jun 25 2019

Hi all,

I'm using JDEV 12.2.1.3 and I'm having a problem when I want to export a table to Excel.

When the table contains a checkbox the the export contains only the headers and the first line and then "Export is incomplete due to error ."

When I remove the last column containing the checkbox the export is working fine.

Is there a workaround for this issue?

Thanks Klaas 

                <af:table value="#{bindings.LinesAndSplitLinesLB1.collectionModel}" var="row" rows="#{bindings.LinesAndSplitLinesLB1.rangeSize}" emptyText="#{bindings.LinesAndSplitLinesLB1.viewable ? AproEBPartialProcessingViewControllerBundle.NO_DATA_TO_DISPLAY_ : AproEBPartialProcessingViewControllerBundle.ACCESS_DENIED_}" rowBandingInterval="0" rowSelection="multiple" fetchSize="#{bindings.LinesAndSplitLinesLB1.rangeSize}" filterModel="#{bindings.LinesAndSplitLinesLB1Query.queryDescriptor}" queryListener="#{bindings.LinesAndSplitLinesLB1Query.processQuery}" varStatus="vs" id="t3" columnStretching="last" horizontalGridVisible="false" verticalGridVisible="false" binding="#{pageFlowScope.PartialProcessingBean.tableLbLines}" selectionListener="#{bindings.LinesAndSplitLinesLB1.collectionModel.makeCurrent}"> 
                  <af:column sortProperty="#{bindings.LinesAndSplitLinesLB1.hints.OriginalLine.name}" filterable="true" sortable="true" headerText="#{bindings.LinesAndSplitLinesLB1.hints.OriginalLine.label}" id="c118"> 
                    <af:outputText value="#{row.OriginalLine}" shortDesc="#{bindings.LinesAndSplitLinesLB1.hints.OriginalLine.tooltip}" id="ot118"/> 
                  </af:column>  
                  <af:column sortProperty="#{bindings.LinesAndSplitLinesLB1.hints.RunNumber.name}" filterable="true" sortable="true" headerText="#{bindings.LinesAndSplitLinesLB1.hints.RunNumber.label}" id="c150"> 
                    <af:outputText value="#{row.RunNumber}" shortDesc="#{bindings.LinesAndSplitLinesLB1.hints.RunNumber.tooltip}" id="ot149"> 
                      <af:convertNumber groupingUsed="false" pattern="#{bindings.LinesAndSplitLinesLB1.hints.RunNumber.format}"/> 
                    </af:outputText> 
                  </af:column>  
                  <af:column sortProperty="#{bindings.LinesAndSplitLinesLB1.hints.FileId.name}" filterable="true" sortable="true" headerText="#{bindings.LinesAndSplitLinesLB1.hints.FileId.label}" id="c151"> 
                    <af:outputText value="#{row.FileId}" shortDesc="#{bindings.LinesAndSplitLinesLB1.hints.FileId.tooltip}" id="ot150"> 
                      <af:convertNumber groupingUsed="false" pattern="#{bindings.LinesAndSplitLinesLB1.hints.FileId.format}"/> 
                    </af:outputText> 
                  </af:column>  
                  <af:column sortProperty="#{bindings.LinesAndSplitLinesLB1.hints.InstanceId.name}" filterable="true" sortable="true" headerText="#{bindings.LinesAndSplitLinesLB1.hints.InstanceId.label}" id="c152"> 
                    <af:outputText value="#{row.InstanceId}" shortDesc="#{bindings.LinesAndSplitLinesLB1.hints.InstanceId.tooltip}" id="ot151"> 
                      <af:convertNumber groupingUsed="false" pattern="#{bindings.LinesAndSplitLinesLB1.hints.InstanceId.format}"/> 
                    </af:outputText> 
                  </af:column>
                  <af:column headerText="#{bindings.LinesAndSplitLinesLB1.hints.ExternalInvoiceFound.label}" id="c115">
                    <af:selectBooleanCheckbox value="#{row.bindings.ExternalInvoiceFound.inputValue}" label="#{row.bindings.ExternalInvoiceFound.label}"
                                              shortDesc="#{bindings.LinesAndSplitLinesLB1.hints.ExternalInvoiceFound.tooltip}" id="sbc3"/>
                  </af:column>
                </af:table>

Comments

Akshs

Nice document

unknown-7404

Excellent summary doc - (aside from the sting of the missing reference to this forum as a resource on page 3!)

3218565

Good Document Steven

Excellent summary doc - (aside from the sting of the missing reference to this forum as a resource on page 3!)

Hmmm. That is a very good point, rp0428! I have corrected my mistake and uploaded a new version. Thanks!

Chris Hunt

Could you enlarge on the points made on Page 8? An example or two would be helpful in understanding what you're trying to say.

Justin Warwick

Is there a way, after compilation, to detect what level of optimization was used? Perhaps you have something already in production, and you just want to find some candidates for recompile (but not necessarily any changes in the source) with increased optimization level.

Is there a way, after compilation, to detect what level of optimization was used? Perhaps you have something already in production, and you just want to find some candidates for recompile (but not necessarily any changes in the source) with increased optimization level.

  SELECT p.plsql_optimize_level

     FROM user_plsql_object_settings p

WHERE name = 'MY_OBJECT'

or find all the program units that are NOT compiled at level 2 or higher:

SELECT *

   FROM user_plsql_object_settings p

   WHERE p.plsql_optimize_level < 2

1 person found this helpful
Justin Warwick

  SELECT p.plsql_optimize_level

     FROM user_plsql_object_settings p

WHERE name = 'MY_OBJECT'

or find all the program units that are NOT compiled at level 2 or higher:

SELECT *

   FROM user_plsql_object_settings p

   WHERE p.plsql_optimize_level < 2

Thank you. Exactly what I was hoping for. And thanks to the engineers, wherever they are, who put this level of detail into the data dictionary. I never cease to be impressed and surprisded by the treasure in there.

1 - 8

Post Details

Added on Jun 3 2019
#application-development-in-java, #excel, #jdeveloper-and-adf
14 comments
401 views