Andrejus Baranovski - ADF Guru Code samples

https://code.google.com/archive/p/jdevsamples/downloads

 Andrejus Baranovskis ADF code base

View Criteria where clause for same attribute ADF

When defining View Criteria where condition like   currency='DOLLAR' or currency is null

Have 2 groups defined with conjunction OR 

group1: currency='DOLLAR'
group2; currency is null

You can't add   currency='DOLLAR' or currency is null is one group

How to keep leading zeros in excel ; Export to Excel ADF

Add 2 outputtexts to the table column

  <af:column width="10%" sortProperty="#{bindings.ExampleVO11.hints.Attribute1.name}"
                                   filterable="true" sortable="true" headerText="InterCompany" id="c33">
                                         <af:outputText value='=" ' inlineStyle="display:none" id="ot14"/>
                            <af:outputFormatted value="#{row.bindings.Attribute1.inputValue}"
                                                shortDesc="#{bindings.ExampleVO11.hints.Attribute1.tooltip}"
                                                id="it32"/>
                            <af:outputText value='"' inlineStyle="display:none" id="ot15"/>
                        </af:column>

Reference : https://flexagon.com/2015/08/adf-export-excel-tweakingchanging-output-for-exported-excel-to-avoid-scientific-formats/