Tuesday Jan 10, 2012

Sort ADF QuickQuery and Query Components Fields with UI Categories

This is a quick tip about the usage of the quickQuery and query components in ADF.
These two components dynamically create the list of fields that you can query on based on the fields in your View Object. The tricky part is that sometimes the order of the fields as they appear in the query component is not the order you want them to be in.

For example, there is usually a high-frequency field that people tend to query on - and you'll want this one to be the first in your query list.

The way to solve this is using the "UI Categories" area of the ViewObject definition - there you can define the order of the fields that will be used by default.

Here is a quick demo:


Learn about other usages of UI Categories here.

Monday Jan 24, 2011

Dependent LOVs in an af:query component

I showed before how simple it is to create a dependent or cascading LOV using ADF BC.
This will allow you to filter one list based on the selection in another list.
However, if you'll try to get this to work inside an af:query component - it won't work out of the box.
Luckily Steve Muench pointed me to a small setting that will get it to work in an af:query component.
Basically all you need to do is set the autosubmit property of the attribute in the viewObject.

Here is a short demo showing you how to do this. (it starts where the previous video ends).


Friday Jan 07, 2011

Adding an LOV to a query parameter (executeWithParams)

I showed in the past how you can use the executeWithParams operation to build your own query page to filter a view object to show specific rows.
I also showed how you can make the parameter fields display as drop down lists of values (selectOneChoice).

However this week someone asked me if you can have those parameter fields use the advanced LOV component.
Well if you just try and drag the parameter over, you'll see that the LOV option is not there as a drop option.
But with a little bit of hacking around you can achieve this. (without actual Java coding).
Here is a quick demo:

About

me
I'm a Director of Product Management for the Oracle Java Development Tools.
Follow me:
Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today