Kumar A. ADempiere 3.6 Cookbook
Подождите немного. Документ загружается.
ADempiere Customization – Part II
108
10. Select a status other than Clarication. The eld Actioned By appears, as shown in
the following screenshot:
Conguring Default Logic
ADempiere's Default Logic concept is useful when we want to assign some default value to a
eld. The default value can be a static value or can be a derived value. In the MOM window,
we have the Start Date eld, which we would like to default to the current date so that when a
user creates a MOM, it is pre-populated and the user is allowed to change it, if needed. Let us
see how we can accomplish this by using the Default Logic concept.
How to do it...
1. Log in as System/System with the System Administrator role.
2. Go to the Window, Tab, and the Field window and open the detail of the Start Date
eld of the MOM tab on the Field tab.
3. Specify @Date@ as the eld value of Default Logic.
Chapter 3
109
4. Log out and log in as GardenAdmin/GardenAdmin with the GardenWorld
Admin role.
5. Go to the Minutes Of Meeting window.
6. Click on the New Record toolbar button. This will populate the Start Date with
the current date, using the Default Logic.
Creating a new window from an
existing window
Suppose there is a business need where a business wants two MOM windows to be
available for two different purposes—one for a Query Only (search) window and another for a
Transaction (create) window. Moreover, there is no change in the number of tabs and elds on
these windows. If this is a need, ADempiere provides an efcient way to replicate a complete
window (including its tabs and elds) from an existing window. In this recipe, we'll see what
that way is.
How to do it...
1. Log in as System/System with the System Administrator role.
2. Go to the Window, Tab, and the Field window and click on the New Record
toolbar button.
ADempiere Customization – Part II
110
3. Fill in the window detail and click on the Copy Window Tabs button, as shown in the
following screenshot:
4. On the pop-up window, select the Minutes Of Meeting window and click on the tick
button. This will copy all the tabs and their respective elds from the Minutes Of
Meeting window to the Existing MOM window, as shown in the following screenshot:
Chapter 3
111
5. Verify the Tab to ensure that all the tabs are copied, as shown in the
following screenshot:
6. Verify the Field tab to ensure that all the elds of different tabs are copied, as shown
in the next screenshot:
Conguring a Lookup Record
ADempiere, for the tables where we have too many transactions happening and the volume
of data is generally high, can automatically provide a Lookup Record window to lter the data
and access the requested data efciently. This window pops up when you click on the menu
item. In this section, we will look at the steps involved in conguring a Lookup Record window.
ADempiere Customization – Part II
112
How to do it...
1. Log in as System/System with the System Administrator role.
2. Go to the Table and Column window.
3. Look up the details of the c_mom table.
4. Check the High Volume checkbox, as shown in the following screenshot:
With this done, the Lookup Record window is congured. It will, by default, prompt
the user for the Key and the Name. Further steps are required in case we want to
add more elds to the Lookup Record.
5. Go to the Column tab.
6. Check the Selection Column checkbox from the columns, which you want to appear
on the Lookup Record window. Say, I have checked the selection for Start Date, as
shown in the next screenshot:
Chapter 3
113
7. Log out and log in as GardenAdmin/GardenAdmin with the GardenWorld Admin role.
8. Click on the Menu | MOM | Minutes Of Meeting. If there are not many records in
the table, you would see the Minutes Of Meeting window, directly, without seeing the
Lookup Record window.
The Lookup Record window appears only if the number
of records in the table is more than 10.
So how do we test to see if I have fewer records?'. Don't worry. There is another way to verify how
your Lookup Record window will look and function. Click on the Lookup Record toolbar button
on the Minutes Of Meeting window. Besides Key and Name columns, you will see the other
columns for which you had checked the Selection Column on the Table and Column window.
ADempiere Customization – Part II
114
Dynamic validations
Dynamic validation is used to lter the valid choices based on the value entered/selected in
some other eld 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 specic 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:
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 FROM
c_momstatus;
Chapter 3
115
Note down the ad_client_id, as 0 shows that it was created by the System user. We need
to lter these out.
How to do it...
1. Log in as System/System with the System Administrator role.
2. Go to the Menu | Application Dictionary | Validation Rules window and create a
new validation rule of the type SQL, as shown in the next screenshot, and specify the
following as Validation code:
ad_client_id<>0
3. Log out and log in back as System Administrator so that the newly created validation
rule gets loaded.
4. Go to the Table and Column window and open the details of the MOM Status column
on the Discussion Detail table.
ADempiere Customization – Part II
116
5. Select MOM Status Validation as the Dynamic Validation, as shown in the
following screenshot:
6. Log out and log in as GardenAdmin/GardenAdmin with the GardenWorld
Admin role.
7. Go to the Discussion Detail tab of the Minutes Of Meeting window. Notice that the
status values are ltered, as shown in the following screenshot:
Chapter 3
117
Customizing the default print format
of a window
This recipe describes the steps to customize the default print format of a window, which
displays the information of an active tab only.
How to do it...
1. Log in as GardenAdmin/GardenAdmin with the GardenWorld Admin role.
2. Go to the Minutes Of Meeting window.
3. Click on the Report toolbar button. This will show the report in the default format,
as shown in the next screenshot:
4. Click on the Customize toolbar button. This will show the Print Format window, as
shown in the following screenshot: