JDev/ADF sample - Nice Trick to Get ADF LOV Description Text

• Nice Trick to Get ADF LOV Description Text. I will tell you about nice trick to display LOV description. Usually you would create separate attribute in VO for LOV description and base LOV on this attribute (read about it in my previous post - Defining the LOV on a Reference Attribute in Oracle ADF 11g). But there is one more way - it makes it much faster to define LOV on description, but you should be aware about additional SQL statement executed to fetch description text.

Download - ADFLovDescriptionApp.zip

JDev/ADF sample - Skip LOV Validation for ADF BC Bulk Insert

• Skip LOV Validation for ADF BC Bulk Insert. This post is about ADF BC LOV. I will describe how you could optimize bulk insert of new rows into VO, when some of the attributes are assigned with LOVs. By default ADF would validate new row attribute value through LOV (LOV Validation and Programmatic Row Insert Performance) for each new row. This will lead to bad performance, especially if you insert a set of new rows programmatically - there will be multiple SQL queries executed to check if LOV attribute value exists.

Download - LOVValidationBulkInsertApp.zip

JDev/ADF sample - ADF LOV Auto Suggest Functionality

• ADF LOV Auto Suggest Functionality. ADF Faces LOV component can be easily enabled with auto suggest functionality. This is really powerful feature and should save time for user to search for required list values.

Download - ADFLovAutoSuggestApp.zip

JDev/ADF sample - Smart Combo Box LOV Based on Description Attribute

• Smart Combo Box LOV Based on Description Attribute. I had a question from blog reader for my previous post about smart Combo Box LOV - Smart Combo Box LOV with Filter. Reader was asking if it is possible to define Combo Box LOV on description rather than ID attribute. ADF BC out of the box allows to define LOV on readonly description attribute. I had a post about it - Defining the LOV on a Reference Attribute in Oracle ADF 11g. Today I will test and describe how the same can be applied for Combo Box LOV in ADF 12c.

Download - SmartComboLOV_v2.zip

JDev/ADF sample - Smart Combo Box LOV with Filter

• Smart Combo Box LOV with Filter. Combo box LOV with filtering is simple, but effective feature not used often. You should rethink LOV design and apply combo box LOV with filtering where possible. Advantage of such LOV implementation is pretty clear - fast list items access, based on filter criteria. This will reduce number of times required to open LOV popup and improve performance of UI.

Download - SmartComboLOV.zip

JDev/ADF sample - Case Insensitive Search in LOV - Effective and Generic

• Case Insensitive Search in LOV - Effective and Generic. Search in LOV dialog window, by default is not case insensitive. You could define View Criteria for LOV VO with case insensitivity and select this criteria to be displayed in LOV dialog. You could do this for one or two, may be for ten LOV's - but I'm sure you are going to get tired pretty soon. Much more effective is to implement generic solution to convert LOV search criteria to be UPPER case automatically.

Download - ADFDynamicReportUI_v6.zip

JDev/ADF sample - Workaround for Infamous Bug 13626875

• Workaround for Infamous Bug 13626875. There is such issue logged on Metalink - inputListOfValues Field Not Updated When Selecting A Value Violating A Unique Key. (Doc ID 1402074.1). This is related to LOV functionality and validation. As per Oracle statement - LOV list must include only valid values, list should not return invalid values, this is by LOV design. However, this doesn't sound logical in most of the cases - often LOV may contain complete list of values and for specific attribute we need to enforce validation to accept only a subset of all values available in the list. Despite Oracle answer as such functionality is not possible b design, there is workaround to make it work.

Download - LOVValidationApp.zip

JDev/ADF sample - Create Row from the Standard ADF UI LOV Component

• Create Row from the Standard ADF UI LOV Component. There is one less known feature of ADF UI LOV component. There is a way to enable additional built-in button for ADF UI LOV popup, this button is rendered as create type icon. Custom popup can be attached to that button and then we can render pretty much anything from that custom popup. I will show you how this is done, based on Oracle ADF UI developer guide - Create Icon in Toolbar of Popup Dialog. This is useful when you want to allow users to maintain the list directly from ADF UI LOV popup.

Download - LOVNewRowApp.zip

JDev/ADF sample - Cascading LOV's in JDeveloper 11.1.2.3.0

• Cascading LOV's in JDeveloper 11.1.2.3.0. Blog reader was asking about cascading LOV's support in JDeveloper 11.1.2.3.0 (latest release). Question was based on my old post from 2008 - Cascading LOV's in Oracle ADF 11g Update 1. Things changed since then - its easier to implement cascading LOV's with the latest JDeveloper 11g releases. I decided to update old sample application and describe how you can implement such functionality using ADF BC declarative tools.

Download - CascadingLOV_v2.zip

JDev/ADF sample - Primary Key Importance for LOV View Object

• Primary Key Importance for LOV View Object. Keep in mind, if you want to enable ADF Faces LOV component for autocompletion - you must have primary key defined for LOV View Object (even this View Object is readonly). Otherwise, ADF Faces LOV component may not function properly - new value will not be accepted and reverted back to original one.

Download - LOVPrimaryKeyApp.zip

JDev/ADF sample - Comparing Number of SQL Executions to get LOV Description With Entity Association Available

• Comparing Number of SQL Executions to get LOV Description With Entity Association Available. This post is logical continuation for my last post - Comparing Number of SQL Executions to get LOV Description Without Entity Association Available, where I was comparing number of SQL executions for different methods without involving EO association. Today I will check how it works when EO association is available. Keep in mind, all what is discussed in previous and this post is related to the case when we define LOV on description field directly, without showing ID value (most common use case, from my experience).

Download -  LOVByName_v2.zip and LOVByNameGroovyAssoc_v2.zip

JDev/ADF sample - Hide or Show LOV Based on LOV RowSet Size

• Hide or Show LOV Based on LOV RowSet Size. If you were ever wondering, how to show or hide LOV component dynamically, depending if there are values in LOV or if it is empty - I will describe it in this post. Sample application contains Departments LOV VO with View Criteria and Bind Variable to filter based on Manager ID.

Download - ChoiceListRendering.zip

JDev/ADF sample - Defining the LOV on a Reference Attribute in Oracle ADF 11g

• Defining the LOV on a Reference Attribute in Oracle ADF 11g. Yesterday I got a question from my blog post reader about LOV components, about how to use LOV components on a reference attributes. Actually, its quite common requirement to have reference attribute shown in LOV, and not its code. I knew it from before, this functional requirement can be implemented in ADF 11g, Steve Muench described it in Oracle Magazine article year ago. However, I decided to implement sample application for this requirement and to give more light on this topic.

Download - LOVByName.zip

JDev/ADF sample - LOV Query Validation in Query Criteria

• LOV Query Validation in Query Criteria. I have noticed in latest JDeveloper 11g release, LOV components present in Query Criteria are not validated by default. In order to make it work correctly, you need to change attribute property in View Object. Here I'm describing how to validate LOV components in Query Criteria.

Download - LOVQueryValidation.zip

JDev/ADF sample - Workaround for LOV on Primary Key Attribute in Create Mode

• Workaround for LOV on Primary Key Attribute in Create Mode. In February, I was blogging about - Workaround for LOV on Primary Key Attribute. Provided workaround and sample application was working nicely, but it was working only in edit mode, when already existing row was updated. There was a need in my project, to update previously developed workaround in order to have working functionality when current row is in create mode. I'm posting updated sample application, you can download it.
  

Download - LOVPrimaryKeyCreate.zip

Spanish Summary:

Este post es una actualización de un post anterior en el que Andrejus muestra como evitar un bug que se produce cuando queremos trabajar con una Lista de Valores (LOV) sobre un campo de una tabla. El post anterior solo consideraba el uso de LOV cuando la tabla estaba en modo de consulta, sin embargo esta actualización considera las tablas en modo creacion y lectura.

JDev/ADF sample - Workaround for LOV on Primary Key Attribute

• Workaround for LOV on Primary Key Attribute. There is a problem with LOV component, when it is defined on Primary Key attribute - registered Bug #8275169. Until problem will be fixed, workaround can be as following - to define second dummy transient attribute for Primary Key attribute and use it on the page. However, during commit - in doDML method on Entity to substitute real attribute value with value from transient attribute.

Download - LOVPrimaryKey.zip

Spanish Summary:

Este artículo se describe un Tip para solucionar un bug que se produce cuando se utiliza una Lista de Valores (LOV) para recuperar un dato en un formulario.

JDev/ADF sample - Cascading LOV's in Oracle ADF 11g Update 1

• Cascading LOV's in Oracle ADF 11g Update 1. I was very happy, when have noticed that Oracle have fixed null value bug in LOV component, I have described couple of weeks ago. This bug is fixed in newest JDeveloper 11g release - JDeveloper 11g Update 1. At first, this bug looks quite funny, however it was affecting lots of functionality related to LOV components. One of such examples is Cascading LOV functionality, previously it simply wasn't working, since it was impossible to assign null value to child LOV, if parent LOV value was changed. Now it works fine.

Download - CascadingLOV.zip

Spanish Summary:

Titulo: Listas de Valores en cascada en ADF 11.

Resumen: Este capitulo muestra como construir listas de valores dependientes una de otra como el clásico (PAIS - DEPARTAMENTO). Andrejus destaca la solución de un bug que tenia esta funcionalidad pero que ha sido solucionada en la versión reciente de la herramienta.