How to Create View
In this example, we are going to create a complex View of the Status History table for Purchase Orders –
Navigate to Options \ Utilities \ Table Schema and select the Add button
In the Configure TAB:
• Enter an informative Table Name + _FW ..this example PO_STATUS_VIEW_FW hopefully describes to the
User that this View is of the Statuses in the PO table
• Table Type = VIEW
• Chevin Owned = NO (YES means that the View ‘may’ be deleted if a FWUPDATE is run.
In the Configure View TAB:
• View SQL =
SELECT PO.ORDER_NUMBER_FW, SH.STATUS_CODE_FW, SH.CREATED_BY_FW, SH.CREATED_DATE_FW,
SH.CREATED_TIME_FW FROM STATUS_HISTORY_FW SH JOIN STOCK_PURCHASE_HEADERS_FW PO ON
SH.TABLE_RECORD_NUMBER_FW = PO.RECORD_NUMBER_FW
• View Table = STATUS_HISTORY_FW
• Link Attachment = Link to view table
• Save as Parent = Save as Parent Table
Click SAVE and then click OK to the various messages that appear – it’s worth understanding the messages but these
messages are not required for the purposes of creating a View
Modify Menu
You have now created a View of PO_STATUS_VIEW_FW. It’s time to make the View accessible by adding the View to
the Menu using the following steps:
Navigate to Options \ Utilities \ Modify Menu
Select Add and complete as follows:
Note that a KEYWORD has been added to that only Users with this KEYWORD can view the menu item.
Translation
You have now created a View of PO_STATUS_VIEW_FW
Let’s make the name more appealing
Navigate to Options \ Utilities \ Translations
Select Add and complete the form as follows:
Click on Save
Refresh your browser
How to Create View of Job Card Statuses
In this example, we are going to create a complex View of the Status History table for Job Cards – again, the View is
considered ‘complex’ because the View ‘SQL Query’ contains a ‘JOIN’
Table Schema
• Navigate to Options \ Utilities \ Table Schema
• Select the Add button
• In the Configure TAB:
• Enter an informative Table Name + _FW ..this example of JC_STATUS_VIEW_FW hopefully describes to the
User that this View is of the Statuses in the Job Card table
• Table Type = VIEW
• Chevin Owned = NO (YES means that the View ‘may’ be deleted if a FWUPDATE is run.
In the Configure View TAB:
• View SQL =
SELECT JH.JOB_NUMBER_FW, SH.STATUS_CODE_FW, SH.CREATED_BY_FW, SH.CREATED_DATE_FW,
SH.CREATED_TIME_FW FROM STATUS_HISTORY_FW SH JOIN JOB_HEADERS_FW JH ON
SH.TABLE_RECORD_NUMBER_FW = JH.RECORD_NUMBER_FW
• View Table = STATUS_HISTORY_FW
• Link Attachment = Link to view table
• Save as Parent = Save as Parent Table
Modify Menu
You have now created a View called JC_STATUS_VIEW_FW. It’s time to make the View accessible by adding the View
to the Menu using the following steps:
Navigate to Options \ Utilities \ Modify Menu and select Add
Complete as follows:
Note that a KEYWORD has NOT added meaning that All Users can view the menu item.
How to create a VIEW
Translation
You have now created a View of JC_STATUS_VIEW_FW
Let’s make the name more appealing
Navigate to Options \ Utilities \ Translations
Select Add and complete the form as follows:
Click on Save
Refresh your browser