Including fields from other tables on a form_eng form

• Article Type: General
• Product: Aleph
• Product Version: 19.01

Description:
At time of booking, staff enters a note in the request to indicate any useful details about the request. That note gets included in the booking-request-slip.

At time of loan, it would be useful to have that note appear in the loan-receipt, but the form calls for the z36-note.

I've tried substituting the z37-note in the loan-receipt form, did util-i-6, pulled in new print templates for GUI, but the note field stays blank in the loan-receipt.

Why wouldn't the z37-note work in the loan-receipt form?

Can we get the z37-note in the loan-receipt form?

Resolution:
The columns which can be included on a form_eng .xsl form are those from tables which

1. the butil program which invokes the form includes; or
2. the form_fill program which invokes the form includes.

In both cases the table the tables are included via "form_fill_xml_record" lines, like this:
CALL "form_fill_xml_record" USING
"Znn "

In this case the program is ./form_fill/loan_receipt_xml. It does not include z37.

Since you, as a customer, do not have access to the butil or form_fill programs, another way to tell is to look at what tables' columns are included on the form.

You can use a " grep './z' " command like the following to see the tables/columns:

> grep './z' loan-receipt.xsl

We see that loan-receipt.xsl includes z36 and z30 columns; no z37.

*Note: If the form includes one column from a particular table, other columns from that table can also be included.*
In this case, that means that, though particular z30 and z36 columns are not included in the distributed loan-receipt.xsl, they *can* be included on the form.

See KB 16384-35602 in regard to the inclusion of z13u fields.

• Article last edited: 10/8/2013