Setting the bind parameter to LOV in OAF

How to set the bind parameter to LOV in OAF

Recently i have been facing issues while binding parameters in LOV VO.

There is a small glitch while setting bind parameters in LOV

Consider the below one if you need to a set a bind parameter :

Never mention bind parameter and value, just make the whereClause and place it.

Normal way of bind and assigning values wont work.

Following is the way you need to use for LOV VO

   public void initDeptLOVVO()

    {

    Number dno= new Number(10);

    String whereClause = "deptNo in ("+dno+")" ;

     System.out.println("executed LOV VO ");

     clearCache();

     setWhereClause( whereClause );

     executeQuery();

     System.out.println("Dept Lov QUery-->"+getQuery() ) ; 

    }

attachmentImage

OAF  attaching images

Item Style: attachmentImage

entityMap1 à Entity à’EMP_LEARNING’ (user defined entity name)

 Set viewAttribute à Empno(PK of the table EO Based One)

 Final Page

Attached Tables