Projects:Extensible Attributes

Contents 1 Purpose 2 Functional specifications 2.1 Window/Tab 2.2 New fields

Purpose

This module will allow users to:

• Add new fields (with their corresponding database columns) to existing tabs
• Add new tabs (with their corresponding tables) to existing windows
• Add new windows

Functional specifications

This module will have one window with two tabs. The main tab will be used to create or select windows and tabs, and the second tab will be used to create new fields.

Window/Tab

You can use this tab to create a new window and or a new tab, in your module. The following fields will be shown in this tab:

• Client (non editable, client 0)
• Organization (non editable, organization *)
• Module: list of modules currently in development
• Hide technical details (check)
• Existing Window: check
• Window: list of the windows in the system (only visible if existing window=yes)
• Existing Tab: check
• Tab: list of tabs in the system

If "Existing window" is not checked, the following fields will allow the user to provide enough information to create a new window:

• Window name
• Window type? (default maintenance?)
• Window description
• Window help

If "Existing tab" is not checked, the following fields will allow the user to provide enough information to create a new tab:

• Tab name
• Table name
• DB Table name
• DAL table name
• Tab description
• Tab help
• Child of
• After tab

Finally, there are also two buttons:

• Generate DB: this button will activate a process which exports the created window, tab, and fields to XML files, and will update the database, creating the desired objects, both in the application dictionary, and in the database physical structure (tables and columns).
• System rebuild: this button will show the Module Management Console, so that the user can easily activate the rebuild of the modified module.

New fields

You can use this tab to create new fields in the selected (or created) tab. The following fields need to be filled:

• Client:System
• Org
• Window/tab: (parent, non editable)
• Hide technical details
• Naming como los tabs (una columna menos, field name, column name, db column name)
• Description
• Help
• Field type: (references of datatype D)
• Field subtype
• Validation (depends on field type)
• Default: (list which changes according to field type)
• Default expression (nice to have, hard...)
• Is mandatory (check)
• Read only (check)
• Identifier (check)
• Updatable (check, not sure?)
• Filter field (check)
• Create at the end (check)
• same line (check)
• After field
• Is used in sorting the tab (check, added at the end)
• Show in grid
• Is first focused field

Button: Preselect from Element (?)

Category: Projects ERP