Next ADF Training
Join Demo Session
Toggle Bar
  • Home
    Home This is where you can find all the blog posts throughout the site.
  • Categories
    Categories Displays a list of categories from this blog.
  • Tags
    Tags Displays a list of tags that have been used in the blog.
  • Bloggers
    Bloggers Search for your favorite blogger from this site.
  • Team Blogs
    Team Blogs Find your favorite team blogs here.
  • Archives
    Archives Contains a list of blog posts that were created previously.
  • Login
    Login Login form

Add In clause operator in view object criteria using custom operator.

Posted by on in ADF UI
  • Font size: Larger Smaller
  • Hits: 565
  • 0 Comments
  • Subscribe to this entry
  • Print
  • Report this post

In JDeveloper 12c there is a feature called add custom operator in view criteria, default operators are commonly using in many places, in some cases we need to have additional operators.

In sql developer we can use In clause parameter directly which jdeveloper doesn’t have by default.

 

b2ap3_thumbnail_sqldeveloperinparamer.png

Here we are going to add In clause operator in Jdeveloper view criteria with the following steps

1.       Open your view criteria in view object

 b2ap3_thumbnail_defaultoperators.png

2.        Go to custom operators tab and click add custom icon

b2ap3_thumbnail_addcustomoperatortab.png

3.       Add In clause operator with the following expression

"IN((select regexp_substr(:bindvariable,'[^,]+', 1, level) from dual connect by regexp_substr(:bindvariable, '[^,]+', 1, level) is not null))"

 b2ap3_thumbnail_inoperatorexpressionadded.png

4.        After success add choose in clause operator for your attribute with bind variable

b2ap3_thumbnail_inoperatorchoosing.png

5.       Now run ADF page with that view criteria and use your search values as follows

b2ap3_thumbnail_inoperatorinpage.png

 

Note: For using  ( , ) operator your attribute and bind variable type should be in string.

 

Have a nice day …J

0
  • No comments found

Login