The user can interact with database using ADF ViewObject. ViewObject returns a query that we can convert as datacontrol for accessing in the ADF pages.
By default ADF ViewObject query retuens select query with select all the fields from the table. But if we want to customize our query and wants to add any clauses,
we can do this by adding a new bind variable.
Edit the ViewObject query and and add the clause.
Example :
Initial Query :
SELECT Profile.USERNAME,
Profile.FIRSTNAME,
Profile.MANAGERID,
Profile.LASTNAME,
Profile.EMAILID,
Profile.COMPANY,
Profile.ADDRESS,
Profile.POBOX,
Profile.COUNTRY,
Profile.CONTACT,
Profile.MANAGER,
Profile.USERID,
Profile.DESIGNATION,
Profile.DEPARTMENT,
Profile.SALARY,
Profile.IMAGE,
Profile.BLOGURL,
Profile.ROWID
FROM PROFILE Profile
The customized Query :
SELECT Profile.USERNAME,
Profile.FIRSTNAME,
Profile.MANAGERID,
Profile.LASTNAME,
Profile.EMAILID,
Profile.COMPANY,
Profile.ADDRESS,
Profile.POBOX,
Profile.COUNTRY,
Profile.CONTACT,
Profile.MANAGER,
Profile.USERID,
Profile.DESIGNATION,
Profile.DEPARTMENT,
Profile.SALARY,
Profile.IMAGE,
Profile.BLOGURL,
Profile.ROWID
FROM PROFILE Profile
WHERE Profile.USERNAME = :Loggeduser
Add a new binding variable with the following fields:\
Name : Loggeduser
Type : String
Value Type : Expression
value : adf.object.viewObject.loggeduser
After that go to the java tab, Create Java class for :"generate view object class" and select the checkbox, "include binding variable accessors"
And add the logic for the loggeduser. In this example, I have added the logic for returning the currently logged in user.
Java Class : ProfileViewImpl
package myportal.model;
import oracle.adf.share.ADFContext;
import oracle.adf.share.security.SecurityContext;
import oracle.jbo.server.ViewObjectImpl;
// ---------------------------------------------------------------------
// --- File generated by Oracle ADF Business Components Design Time.
// --- Thu Jan 10 09:13:01 GST 2013
// --- Custom code may be added to this class.
// --- Warning: Do not modify method signatures of generated methods.
// ---------------------------------------------------------------------
public class ProfileViewImpl extends ViewObjectImpl {
/**
* This is the default constructor (do not remove).
*/
public ProfileViewImpl() {
}
/**
* Returns the bind variable value for Loggeduser.
* @return bind variable value for Loggeduser
*/
public String getLoggeduser() {
SecurityContext securityContext=ADFContext.getCurrent().getSecurityContext();
if(securityContext != null)
{
System.out.println("SecurityContext is initialized");
return securityContext.getUserName();
}
else
{
System.out.println("SecurityContext is not initialized, returning weblogic");
return "weblogic";
}
}
/**
* Sets <code>value</code> for bind variable Loggeduser.
* @param value value to bind as Loggeduser
*/
public void setLoggeduser(String value) {
setNamedWhereClauseParam("Loggeduser", value);
}
}
How can i bind application URL param(?cust_id=100) to ADF BC view object groovy expression binding variable? I should pass some value by URL from other appication like ebs or otm to adf(my application).
ReplyDeletethanks in advance
Reg/Senthil
same problem here.. i want to get bind variable value from URL. but i can't use facescontext in Impl class. help
ReplyDelete