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

Configuring a new print format for a window

This recipe describes how we can configure a print format for a window where we can display information from different tabs on that window.

How to do it...

  1. Create a view from the different tables, used in the window.
    CREATE VIEW adempiere.c_mom_v AS
    SELECT
    a.*,
    b.item_nbr,b.discussion_desc,b.ad_user_id AS actioned_by,b.c_momstatus_id,
    c.ad_user_id AS participant,c.company,
    d.name AS status
    FROM
    adempiere.c_mom a
    JOIN adempiere.c_mom_discussionline b ON a.c_mom_id=b.c_mom_id
    JOIN adempiere.c_mom_participantsline c ON c.c_mom_id=b.c_mom_id
    JOIN adempiere.c_momstatus d ON b.c_momstatus_id=d.c_momstatus_id;
    
  2. Go to the Table and Column windows and create table and columns from the c_mom_v view, as shown in ...

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