O'Reilly logo

ADempiere 3.6 Cookbook by Ajit Kumar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Dynamic validations

Dynamic validation is used to filter the valid choices based on the value entered/selected in some other field on the screen. For example, on a screen, say, you want to load the business partners who belong to a selected business partner group.

In this recipe, we will apply this functionality of ADempiere to see how we can make use of it to achieve our specific goal.

Getting ready

On the Discussion Detail tab, we see duplicate values in the MOM Status drop-down list, as shown in the next screenshot:

Getting ready

Find out the details about all the statuses, as shown in the next screenshot, by running the following SQL query:

SELECT ad_client_id,c_momstatus_id,name,isdefault,value ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required