Tersus: Re: add a field to wizard table

Re: add a field to wizard tableDate: Jan 23, 2012Tags:Table WizardHi,Sorry for the late response, but I hope you will find it useful.Assuming you want the field to be displayed in the table, you have 2 options:

Delete the existing table completely, and create a new one with the table wizard, using the import structure from database option to reimport the existing table fields.
This option is irrelevant in cases where you've already made significant changes to the original model, since you'll need to implement all these changes again.

Add the field manually as follows (all model paths mentioned are relative to the Wizard package created by the wizard):

Add the relevant field to Database/Database Record

Add a matching input field to Table Row/Table Row

Add a matching row, containing label and input field to Details Grid/Details Grid

Add the relevant flows between record and row/grid to Convert Record to Row/Convert Row to Record/Convert Record to Grid/Convert Grid to Record/Merge Records in the Transformations package

Modify Transformations/Init From Filter Row Visibility, setting the new fields visibility to Yes if it participates in any type of filtering, else set it to No

Modify Transformations/Init To Filter Row Visibility, setting the new fields visibility to Yes only if it participates in Range fitlerring, otherwise set it to No

If the field participates in Range filterring, modify Transformations/Extract From Constraints and Transformations/Extract To Constraints, adding the relevant flow to both

If the field participates in Exact filtering, modify Transformations/Extract Match Constraint, adding the relevant flow

If the field participates in Starts With filtering, modify Transformations/Extract Match Constraint, reusing Common/Templates/Modules/Rich Table/Prototypes/Shared/Create Starts With Pattern

If the field participates in Contains filtering, modify Transformations/Extract Match Constraint, reusing Common/Templates/Modules/Rich Table/Prototypes/Shared/Create Contains Pattern

Note, that if all you wish is for the field to be included in the database table, but not displayed in the table, just add it to the Database Record.Regards,DavidSee Also:

To use the full functionality of this web site, JavaScript needs to be turned on.

For best results, use the Firefox browser..

Loading ...