Thursday Dec 15, 2011

Filtering Records by Time with ADF Business Components

I posted in the past a demo showing how you can get a time selector part to your date field using the right format mask and data type.

A question on the OTN forum asked how do you filter data in a view object based on time (and not only date).

Here is a quick example - the basic things to keep in mind is that you need to set your parameters to not be the default Date but rather timestamp and also you'll need to configure the UI hint for the format of the parameters you are using.

Here is a quick demo:

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