Oracle Forms to ADF & JET Migration
Free Estimation
Toggle Bar
Featured

Query a View Object using View Criteria

import oracle.jbo.VariableValueManager;

import oracle.jbo.ViewCriteria;

import oracle.jbo.server.ApplicationModuleImpl;

import oracle.jbo.server.ViewLinkImpl;

import oracle.jbo.server.ViewObjectImpl;

 

public void applyVCforGlobalSearchProjects(String searchCriteria){

    ViewObjectImpl vo;

    vo = this.getProjects();

    ViewCriteria vc = vo.getViewCriteria("HrProjectsVOCriteria");

    vc.resetCriteria();

    VariableValueManager vvm = vc.ensureVariableManager();

    vvm.setVariableValue("p_search_criteria", searchCriteria);

    vo.applyViewCriteria(vc,true);

    vo.executeQuery();

}

 

Continue reading
2088 Hits
0 Comments

Login

Cron Job Starts