Ashish Awasthi's Blog

Monday 24 March 2014

Iterating ViewObject vertically (get all attributes of ViewObject) programmatically

Hello All,
This post talks about a requirement of getting all attributes (column names) of a viewObject programmatically

Create a fusion web application and business component using department table

you can see all attributes in Departments entity object

Now to get ViewObject's attributes name , there is a method written in AMImpl class , see it, i have added a facesMessage to show all names on a Message Board

    /**Method to get all attributes of a viewObject
     * */
    public void iterateVoVertically() {
        ViewObjectImpl vo = this.getDepartments1();
        ViewAttributeDefImpl[] attrDefs = vo.getViewAttributeDefImpls();
        int count = 0;
        StringBuilder infoMsg =
            new StringBuilder("<html><body><b><p style='color:red'> Attribute of Department ViewObject are-</p></b>");
        infoMsg.append("<ul>");


        for (ViewAttributeDefImpl attrDef : attrDefs) {
            byte attrKind =
                attrDefs[count].getAttributeKind(); //checks attribute kind for each element in an array of AttributeDefs
            if (attrKind != AttributeDef.ATTR_ASSOCIATED_ROW && attrKind != AttributeDef.ATTR_ASSOCIATED_ROWITERATOR) {
                String columnName = attrDef.getName();
                infoMsg.append("<li> <b>" + attrDef.getName() + "</b></li>");
                System.out.println("Column Name-" + columnName);
            }
        }
        infoMsg.append("</ul><br>");
        infoMsg.append("</body></html>");
        FacesMessage msg = new FacesMessage(infoMsg.toString());
        msg.setSeverity(FacesMessage.SEVERITY_INFO);
        FacesContext.getCurrentInstance().addMessage(null, msg);
    }

I have called this method through page binding and AM Client on a button of page

now on click of button all attributes of Departments ViewObject are shown in FacesMessage, you can use it in your code

Cheers :-)

Saturday 8 March 2014

Launching browser print dialog using simple javascript function in ADF

Hello All ,
This posts talks about a requirement of printing a simple page (not much component as, form,tree,etc & not much data)
you can use a simple one liner javascript function to invoke browser's print dialog.

there is a page with Departments table on it, and a button to print this page

Called this simple javascript function on button click to open print dialog

window.print();

to execute javascript through managed bean use this method

    /**Method to execute Javascript
     * @param javascriptCode
     */
    public static void runJavaScriptCode(String javascriptCode) {
        FacesContext facesCtx = FacesContext.getCurrentInstance();
        ExtendedRenderKitService service = Service.getRenderKitService(facesCtx, ExtendedRenderKitService.class);
        service.addScript(facesCtx, javascriptCode);
    }

click on print button- In Google Chrome

In Mozilla-

after printing, the page look like this

Sample ADF Application- Download
Cheers :-)

Wednesday 5 March 2014

Igonre null values in viewCriteria -Jdeveloper 12c (Not a bug but a change)

Hello All,
In jdev 12c there is some change in viewCriteria design window, there is a checkbox to ignore null values in criteria , in 11g release it was enabled for all values in criteria item

but in 12c it is disabled for all values of ViewCriteria bind variable

there is two different section for creating bind variable in 12c
1. ViewCriteria Bind Variable
2. Query Bind Variable(Required)
So when you create a bind var of string type in query variables.

and use it in viewCriteria , only then this 'ignore null values' checkbox will be enabled

and when you use viewCriteria bind varibles it is disabled but sometimes you need to change it, so can change it using ViewObject xml source

Select ViewCriteria and go to source

Now change GenerateIsNullClauseForBindVars="false" to true

Cheers :-)

Tuesday 4 March 2014

Showing white-spaces properly in ADF table column- 11g & 12c

Hello All,
This posts talks about a requirement of showing white-spaces before any text/number in an af:table
Suppose i have , form and table of a ViewObject on page

Case 1- both table and form are editable , in this case you can see that white spaces are properly visible in both form and table

but normally in applications we have a read-only table and editable form so in this case you can see that white-spaces are not visible in table

But sometimes we need to show spaces in table same as in form so to do this select that field and go to property inspector and select component

Now set it's contentStyle (for input component as- af:inputText) or inlineStyle (for display component as- af:outputText)- white-space:pre;

now run your page and see-

Cheers :-)

Tuesday 28 January 2014

Disabling keyboard input in af:inputDate, restrict user to use calendar only - Oracle ADF

hello all,
this tutorial is about a requirement of restricting user to enter date through calendar only in ADF application
this trick was posted by Frank Nimphius (ADF Code Corner)

Drop a af:inputDate component on page from component pallete

Now set its background color so that it looks like disabled field

Now to make it's input field disable, we have to write a small javascript function, copy this function and paste in your page source (XML)

<af:resource type="javascript">
          function enableCalendarOnly(evt) {
              evt.cancel();
          }
        </af:resource>

Now drop a af:clientListener under af:inputDate component to invoke javascript

Now set properties in af:clientListener as Method & Type

Now run your page and see that input field is disabled for date component , now value can be selected using calendar only

Cheers - Happy Learning :-)

Sunday 19 January 2014

Hiding search icon of af:inputListOfValues using CSS & ADF Skin

Hello All,
Hope all are doing good, this post talks about skinning inputListOfValues to hide its search icon (magnifying glass)
we can use the auto-suggest feature in inputListOfValues so if we don't want to display that default search icon then what to do?

inputListOfValues looks like this in ADF Faces

I have created a page and dropped 2 inputListOfValues on page

there is 2 types of requirement about hiding search icon

Hide icon of all inputListOfValues(LOVs) available on page or application
Hide icon of some selected fields

to do this we have to create a CSS (skin) in application

give relevant name of CSS file and set this file as default skin of application

Now to hide icon of the selected inputListOfValues component in an application, go to the source of CSS file and just write this code

.TagSearchIconHidden af|inputListOfValues::search-icon-style
{
display: none;
}

Now go to the page and paste TagSearchIconHidden in StyleClass property of lov component to hide its icon, run your page and see, I have done this in my first LOV

Now to hide icons of all lov component just change CSS file with this script

af|inputListOfValues::search-icon-style
{
  background-image: none; 
}

Now no need to set StyleClass, it is applicable to all lov components of the application

Cheers :-)

Creating new object in list (af:inputListOfValues) using 'createPopupId' feature- ADF 11g & 12c

Hello All ,
This post is about a good feature provided with inputListOfValues in ADF .
inputListOfValues is used where large and complex data is populated in list, this component supports search in list values
Suppose on opening list values you want to add one more value in list generally to do that you will close the list and add a value in source table then again open list but this feature provide instant creation of list values

this functionality can be achieved in Combo Box with List of Values using customActions facet, i have posted about it
Create new look up data using List of Values (LOVs) in Oracle ADF

so this time it is about inputListOfValues, see the steps to do

Created a fusion web application and business components using Departments and Employees table of HR Schema

now i have created list of values on DepartmentId of Employees ViewObject referenced from Department ViewObject, display type is Input Text with List of Values

drop Employees VO on page and run, it looks like this

Now i have dropped a popup on page and to create new value in list, i have dropped form of Departments ViewObject and a link to create it on dialog inside popup

select list of values component (Employee VO) in structure window and go to property inspector and set popUp id in a property called 'createPopupId'

After setting 'createPopupId' ,on running a commandToolbarButton appears in the LOV popup dialog box with a icon, this button's action triggers custom popUp (i have added before)

on clicking on this icon-

on create link i have just called createInsert for Departments ViewObject and on dialogListener , Execute

import oracle.adf.model.BindingContext;
import oracle.binding.BindingContainer;
import oracle.binding.OperationBinding;



    /**Method to get Bindings of current page
     * @return
     */
    public BindingContainer getBindings(){
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }

    /**Method to execute OperationBinding
     * @param operation
     * @return
     */
    public OperationBinding executeOperation(String operation){
        return getBindings().getOperationBinding(operation);
    }

    /**Method to create new Department
     * @param actionEvent
     */
    public void createDeptAction(ActionEvent actionEvent) {
       executeOperation("CreateInsert").execute();
    }

now created a new department using 'create' link and you can see value is appeared in list values

Cheers :-)

Monday 13 January 2014

Cool Feature- Using 'Placeholder' to set watermark hint on empty input fields in ADF/Jdeveloper 12C

Hello All,
This post talks about a very cool feature , introduced in ADF/Jdeveloper 12C.
Sometimes we need to set some hint on input fields as you can see in facebook sign up form, all fields are self descriptive

So now we can do that in ADF faces easily , in 12C there is a property named 'Placeholder' to define hint for empty fields
You can see in below form (ADF Faces)-

See the xml source of this simple form-

 <af:panelFormLayout id="pfl1">
                    <f:facet name="footer"/>
                    <af:inputText label="Country" id="it1" placeholder="Enter Country Name"
                                  contentStyle="width:200px;color:red;"/>
                    <af:inputDate label="Date" id="id1" placeholder="Select Date"
                                  contentStyle="width:200px;color:red;"/>
                    <af:inputListOfValues label="Country" popupTitle="Search and Result Dialog" id="ilov1"
                                          placeholder="Select Country" contentStyle="width:200px;color:red;"/>
                    <af:inputComboboxListOfValues label="Country" popupTitle="Search and Result Dialog" id="iclov1"
                                                  placeholder="Select Country" contentStyle="width:200px;color:red;"/>
                    <af:inputNumberSpinbox label="Value" id="ins1" placeholder="Enter Or Select"
                                           contentStyle="width:200px;color:red;"/>
                </af:panelFormLayout>

Cheers :-)

Friday 10 January 2014

Oracle ADF Tutorial- How to learn Oracle ADF from scratch ?

Hello All

If you are new to ADF and want to learn this framework then you must be aware of good sources of Oracle ADF tutorials

How to learn Oracle ADF from Ashish Kumar

You must refer a good book to clear your basics as Oracle ADF Real World Developer’s Guide

and start with Oracle ADF Insider videos after that refer Oracle JDeveloper 12c (12.1.3) Tutorials

After this start referring Oracle ADF Blogs for advance development and check all the sample applications provided there, Here you can find some of the best blogs

Oracle ADF Code Corner

Andrejus Baranovskis Blog

Shay Shmeltzer’s Weblog

One Size Doesn’t Fit All

Andrejus Baranovskis Blog

Practical experience on Oracle products

Decompiling ADF Binaries

JDev & ADF Goodies

rsantrod's Blog

Rohan Walia's Tech Blog

Waslley Souza Blog

Techartifact

ADF Practice

In case of any problem any issue related to ADF, Ask in OTN forum

Space: JDeveloper and ADF

Use social media to get new updates about product and blogs

Oracle JDeveloper & ADF

Ashish Awasthi's Blog | Facebook

JDeveloper & ADF

Oracle JDeveloper | Facebook

Cheers :-) Happy Learning

Friday 3 January 2014

Identifying Modified/newely added row in af:table, get all modified rows of viewobject in bean

Hello All,
first of all, a very Happy new year to everyone, learn more and more ADF

this tutorial is about a requirement of showing modified rows on page
Suppose if there is lot of data in af:table and user is modifying some rows then it must reflected immediately on page that which rows are modified for more clarity

Andrejus has also posted about it in 2010
http://andrejusb.blogspot.in/2010/04/changed-row-highlighting-in-oracle-adf.html

But this post talks about two requirements-

Want to highlight modified rows only on page
Want to get modified rows in managed bean

First One could be achieved without writing a single line of code only using expression, a row in table or view object has four state-

New
Modified
Un-Modified
Initialized

/* this expression returns state of current row in collection such as table or treeTable*/
#{row.row.entities[0].entityState} 

/*here row is reference variable of collection, this expression returns an int value if it is 
 2-Modified
 0-New
 1-Unmodified
-1-Initialized
*/

I'm using Departments table of HR Schema to implement this sample app
after business components configuration ,Drop departments VO from data control on page as af:table
Now to check row status , i have written following expression in inline style of af:column of af:table, so that it can check state of all rows of table

#{row.row.entities[0].entityState==2 ? 'background-color:orange' : row.row.entities[0].entityState==0 ? 'background-color:darkgreen' : ''}

Now Run your page and change any value of table

After Updating Values in Row- see modified rows are highlighted

Now you are done with first requirement , if we talk about second one, in case you want to get all modified rows in managed bean to perform some operation
To achieve this i have used a transient attribute in Departments view Object to store state of each row
Now in RowImpl of departments viewobject i have to write some code to get current state of Row, see the getter method of transient attribute in RowImpl

    /**
     * Gets the attribute value for the calculated attribute CheckRowStatus.
     * @return the CheckRowStatus
     */
    public Integer getCheckRowStatus() {
        byte entityState = this.getEntity(0).getEntityState();
        return new Integer(entityState);

        // return (Integer) getAttributeInternal(CHECKROWSTATUS);
    }

Now i have placed a button on page to get all modified rows and show a message on page through managed bean
See the method written in ApplicationModuleImpl class and then exposed to client to be used in managed bean action event

    /**Method to get all modified rows and store corresponding Department Name in an ArrayList
     * @return
     */
    public ArrayList<String> getModifiedRows() {
        ArrayList<String> deptNm = new ArrayList<String>();
        ViewObject deptVo = this.getDepartmentsView1();
        RowSetIterator deptIter = deptVo.createRowSetIterator(null);
        while (deptIter.hasNext()) {
            Row nextRow = deptIter.next();
            if (nextRow.getAttribute("CheckRowStatus") != null) {
                Integer rowStatus = (Integer)nextRow.getAttribute("CheckRowStatus");
                if (rowStatus == 2) {
                    deptNm.add(nextRow.getAttribute("DepartmentName").toString());
                }
            }
        }
        return deptNm;

    }

Now call this method in managed bean through Binding Layer

    /**Method to get BindingContainer of current page
     * @return
     */
    public BindingContainer getBindings() {
        return BindingContext.getCurrent().getCurrentBindingsEntry();
    }

    /**Method to call AM method and to show modified rows on page in FacesMessage
     * @param actionEvent
     */
    public void getModifiedRows(ActionEvent actionEvent) {
        OperationBinding ob = getBindings().getOperationBinding("getModifiedRows");
        ob.execute();
        if (ob.getResult() != null) {
            ArrayList<String> deptName = (ArrayList<String>)ob.getResult();
            StringBuilder saveMsg =
                new StringBuilder("<html><body><b><p style='color:red'>Modified Rows in Departments table are-</p></b>");

            saveMsg.append("<ul>");
            for (String name : deptName) {
                System.out.println(name);
                saveMsg.append("<li> <b>" + name + "</b></li>");
            }

            saveMsg.append("</ul><br>");
            saveMsg.append("</body></html>");
            FacesMessage msg = new FacesMessage(saveMsg.toString());
            FacesContext.getCurrentInstance().addMessage(null, msg);
        }
    }

Now again run this page and change some departments then click on get modified rows, it will show currently modified rows

Cheers- Download Sample App

Subscribe to: Posts ( Atom )

Search this blog

Monday 24 March 2014

Saturday 8 March 2014

Wednesday 5 March 2014

Tuesday 4 March 2014

Tuesday 28 January 2014

Sunday 19 January 2014

Monday 13 January 2014

Friday 10 January 2014

Friday 3 January 2014