Weblog for the AMIS Technology corner
Posts tagged viewobject
Weird ADF 11g requirement addressed with left outer join and modern SQL join syntax
Dec 13th
The functional requirement was a little unusual. The page should either show all master-records or – depending on the value of a parameter – it should show exactly one master-record joined with exactly one detail-record. The use case was valid – that was exactly the functionality that was required.
In terms of EMP and DEPT -I like to always simplify things to express them in EMP and DEPT terms – , we should either see all Departments (and no Employee data) or we should see the data for a specific Employee joined with the data for its corresponding Department. And of course we just one to create a single page, and make it as simple as possible to create that page.
A simplistic page that supports this functionality could like this:
when a specific Employee is requested and
when all Departments should be shown, because no single Employee is asked for.
Synchronize ViewObject Queryies by dynamically linking bind parameters
Nov 28th
The functional requirement for my ADF application was fairly simple: the values used for the bind parameters in one ViewObject should be reflected for a second ViewObject. In more functional terms the requirement was the following: when we filter the master records – Employees – by begin year and end year (to only show employees that were hired between the begin and end year) the details – Job History – should also fall within the perioded limited by begin year and end year. The end users complained that when they had set the begin year and/or the end year, they did not like to get job history records that were completely outside that range (even though stricly speaking that is correct).
A similar requirement would be for example when a page shows both orders and complaints for a specific customer and the orders are filtered by date to also have the complaints filtered by that same date.
It is possible to resolve this in the web tier – to retrieve the value of the bind parameters for both ViewObjects from the same bean property. However, when the model based query component is used, the value of the bind parameter is not readily accessible from the web tier.
Fortunately, and often easier to realize, the value of one bind parameter can be bound to a bind parameter on a different ViewObject.
JDeveloper 11g PS 1 has been released – cool stuff!
Nov 14th
Last month during Oracle Open World I wrote an article on the upcoming features of PatchSet 1 for JDeveloper 11g: . Now this release has been published and is delivering on those promises. For an overview of all (?) new features, take a look at What's New. It is a fairly dry, emotionless, factual list of features small, large and enormous new features. With brief descriptions and screen shots for many of them, it gives you a quick overview of what might be useful to you. Note however that some gems are hidden away in this list for which the meaning and importance is not fully captured I believe in this summary. And of course the relevance of any new feature depends on your specific situation.
