How To get Dynamic Menues Using Custom SQL view Object

Today we will Discuss How to get Dyamic Menues In Jsf Page from Menues

For this Purpose We should Have The follwing Concept

• View Objects
• View Links
• Collection Model Tree,Iterotor

So we Will Complete This Topic In Three Tutorial first Of All we should have the basic idea of View Object Which is discuss in this tutorial

Sql Querry base view ViewObject decribes how the application will view and update data. A View Object may be Entity based or non-Entity based. In the former case, the View Object consists of one or more Entity bases. The first one of these is referred to as the primary Entity base. The rest are called secondary Entity bases. An Entity based View Object maps its attribute (View Attributes) to attributes in the Entities (Entity Attributes). An Entity based View Object may map all its Entity Attributes or only some of them. However, an Entity based View Object is required to map all primary key attributes of the Entity bases. An Entity based View Object may additional include attributes that are not mapped to an Entity Attribute. Such an attribute is referred to View level attribute.  A non-Entity based View Object is one where it does not have any Entity base. All its attributes are View level attributes.  View Object is responsible for managing database query statement. Regardless of whether the View Object is Entity based or not, it may have a SQL statement from which it draws its data. As rows are read from this query, it will populate a RowSet (of this View Object) with View rows.  View Object provides a number of APIs through which the client can modify and augment the query statement during runtime. For example, see ViewObject#setWhereClause().  A View level attribute (not mapped to an Entity attribute) may map to a column or a SQL expression in the query statement. It may be a transient attribute (whose data is purely in memory and not mapped to any database column/expression. Or, it may be a dynamic attribute. 

SQL Query Base View Object

 sql query base view object are used to get data from database the example of query base view  are when we get dynamic menus from database in our jsf page

Now we will discuss how to create sql queery base view object from database

Follow The Follwing Steps To Create View Object

1. Click On model and choose View Object From Gallery To create view Object
2. Change The Name Of view Object And Choose custom Sql Querry Then Click Next
   
3. After that write Your Sql Querry (Which ever you want to get from database) and then  on bottom click "Test And Explain" the follwing message will be show "Your Querry executed Successfully"
   
4. After That Click Next on attribute mapping Choose any one option
   
5. After This Choose Primary Key and checked the filed "Key Attribute
   
   
   
6. Then you can click next ,next and in application module checked the boxed add to application module 
7. 

Your View Object Is Ready To Use You can Access it in jsf Page

 Next Tutorial We will Leran How To link View Object  and Then Complete How to Get Dynamic Menues Using Iteroror

Thanx 

Mushtaq Wattu

Skining And Balancing Of ADF Form

ADF form are Very important because in buisness application forms are mostly used .they are backbone of every adf application so today i will discuss you how to design form for your adf application

Follow the follwing steps To create form in adf Application page

 

1)After Creating Jsf Page Drag and Drop panel group layout to you page and set its layout to vertical

2)Now drag a view(for example Employees) and choose form from option  and drop it to

 panel group layout

3)Then change the rows and columns of panel form layout according to your desire

4)now You have to skin your form 

change the background color adf form

 5)now we have to focus input text of our application 

input tex has three part for skin

they are mentoned in the picture below

content style is for input text part and label style is for output text part we can add inline css as well as extrenal css

6) Now we have to balnace all the input text of our form for this purpse  we will write height and width in content style

7 ) Now write this code to chagne the background color of input text we will write this code in adf skin  for global selectors 

    

Your form is ready to use  in perfect balance form

Thanx For Corporating

Mushtaq Wattu

InterDucing Alta UI

Download Alta UI Icons For Your Applications

Get All Alta UI Icon

The Oracle Alta UI system was used to develop the most recent Oracle Cloud products, the latest versions of Oracle Fusion Applications, a number of innovative mobile applications, with many more to come.

• Fully redesigned UI component set and interactions
• Fresh visual design complements modern layout approach
• UI conducive to responsive design techniques
• Native Mobile UI

Download From Here

Alta UI Icons

Thanx 

Mushtaq Wattu

My Blog Demo in Splash Screen

This Demo is All About Alta UI
Jdeveloper Version 12.2.1

Skin For Panel Stretch Layout

You have to use many ways to skining a panel stretch layout Componenet today i will tell you the most easiest way to skining a panel stretch layout Component
To Learn This U should Know About Panel Stretch layout

The panelStretchLayout component stretches the child in the center facet to fill all of available space. The available space may be constrained by the presence of other children in the top/bottom/start/end facets. When these children are present, they occupy space defined by the topHeight/bottomHeight and startWidth/endWidth attributes.

Use The Follwing Code to Change The color Of each Facet of panel Stretch layout facets

          

<af:panelStretchLayout id="psl" topHeight="200" startWidth="200" endWidth="200" bottomHeight="200">

  <f:facet name="top">

    <af:outputText id="t" value="Top" inlineStyle="background-color: #FF6666;"/>

  </f:facet>

  <f:facet name="start">

    <af:outputText id="s" value="Start" inlineStyle="background-color: #FFFF66;"/>

  </f:facet>

  <f:facet name="center">

    <af:outputText id="c" value="Center" inlineStyle="background-color: #FFFFFF"/>

  </f:facet>

  <f:facet name="end">

    <af:outputText id="e" value="End" inlineStyle="background-color: #66FF66;"/>

  </f:facet>

  <f:facet name="bottom">

    <af:outputText id="b" value="Bottom" inlineStyle="background-color: #6666FF;"/>

  </f:facet>

</af:panelStretchLayout>

The Result For This Will be

for This Purpose we use a output text componenet

and we assign value  ,start,top,end,bottom

The Demo Picture For This Will Be

Implement Adf Alta UI Skin For Your Project

Helo EveryBody
Today i want to discuss With you how to implement  adf alta skin for your application
although it is quite simple alta skin is very different from other skins
So lets starts Step by Step

1)Click on view controller of your Project

2)Select New and Choose From Gallery Jsf Page Then ADF Skin

3) Name Your Alta Skin click next

5)After This Choose Alta Skins And Click Finish

4)Your Skin is Ready To Use Choose Selectors to Skin your Project and start Skining Your Adf Project

Always Keep In mind There Is no need to attech this Skin to Your Jsf Page 

because this Skin will Automatically implement to your Project When you skin your Selector and run your jsf page will have Differnet Look

Thanx For Your Participation

Mushtaq Wattu