Create and Apply View Criteria with IN Clause and Other Clause Dynamically in ADF

Get the View Object instance
           
            ViewCriteria vc = vo.createViewCriteria();
            vc.setName("INCriteria");
            String inClause = "IN (10,20,30,40)";
            ViewCriteriaRow criteriaRow = vc.createViewCriteriaRow();
            criteriaRow.setAttribute("DepatmentId", inClause);
            vc.addElement(criteriaRow);
            vo.applyViewCriteria(vc, true);
            vo.executeQuery();

If you want to add the view criteria with equal clause then use following lines of code :

                ViewCriteria vc = vo.createViewCriteria();
                ViewCriteriaRow criteriaRow = vc.createViewCriteriaRow();
                criteriaRow.setAttribute("DepatmentId",10);
                vc.addElement(criteriaRow);
                lovVO.applyViewCriteria(vc, true);
                lovVO.executeQuery();


Comments

Post a Comment

Popular posts from this blog

Setting up the environment for Angular2 and Hello World Example in Angular2

Image
Hi All, In this post I am going you to show you how you can set up the environment for Angular2. You may want to run your application in different servers. So here I am going to show you how you can run your Angular2 application in the following two servers: 1. lite-server (static server) 2. Weblogic Server 10.3 Lets do the setup for lite server.  First of all go to any directory in your computer and create a folder in that directory with name "angular2-example". You can do it by the command line also by typing the following command. mkdir  angular2-example Now once the directory is created you need to create three files. 1. tsconfig.json 2. typings.json 3. package.json 1.  tsconfig.json This file is TypeScript compiler configuration file. It guides the compiler to generate JavaScript files after compilation. The content of this file will be as follows: {   "compilerOptions": {     "target": "es6",     "modu...
Read more

Build a Simple ReactJS application using react-cli

Image
Hi All, In this blog we will see how we can create a sample application using react-cli.  It is a command line interface tool that seeks to automate some tasks when working on a React.js project. To starts with you have to install it globally by running following command: npm install -g react-cli The you have to run the following command in command window: npm install -g create-react-app  Now once it is installed you can create any directory where you want to create you sample ReactJS application. I have created a folder with name "TestApp" in my local drive. Now you have to run the following command to create the sample application. create-react-app testapp  While it is creating application and downloading all the artifacts related to this you can see the following things in command line as shown below: So it will create a ReactJS application with name "testapp" under folder "TestApp" as you can see in the above screenshot. On...
Read more

Customizing the ReactJS sample application created using react-cli

Some time you may want to create the react.js application using react-cli and you may also want to customize it according to your requirements. react-cli command always get the latest version of all the libraries. for instance if you look at the package.json file then you will see the following contents: package.json ======================================================================== {   "name": "testapp",   "version": "0.1.0",   "private": true,   "dependencies": {     "react": "^15.6.1",     "react-dom": "^15.6.1"   },   "devDependencies": {     "react-scripts": "1.0.10"   },   "scripts": {     "start": "react-scripts start",     "build": "react-scripts build",     "test": "react-scripts test --env=jsdom",     "eject": "react-scripts eject"   } } =======...
Read more