Do you want to Search Something?

Those who opened the gates

Friday, August 12, 2011

Playing with Calculated Fields

To create a calculated field that displays the division name of the current logged user creating a service request
In the Service Request business component, create a new calculated field:
Calculated: TRUE
Calculated Value: DivisionName()
Name: Division (Calc)
Parent Name: Service Request
Type: DTYPE_TEXT
In the Service Request Business Component, also create a new join to S_SRV_REQ_X table:
Column: ATTRIB_03
Join: S_SRV_REQ_X
Name: Reported By Division
Pre Default Value: Field:
'Division Name'
Read Only: TRUE
Expose the joined field Reported By Division in the relevant applets.
You may also want to expose the calculated field Division (Calc), just to check the logic and set Visible = False later for the control or list column exposed