Development > Data and parameters > Development setup > Formula wizard setup 

The Adonix software range makes it possible to define within certain parameterization functions, evaluated formulas used to define either a selection criterion or the contents of a field. In order to facilitate the task for those in charge of parameterization, a formula assistant has been provided.

This function is used to define the fields accessible in the left list of the formula assistant. These fields, identified by a name and title, can be of different types :

  • global variable (usually, its code starts with G, it can be prefixed by [V] in the formulas). It must previously have been defined in the global variables dictionary.
  • local variable (it can be prefixed by [L] in the formulas).
  • user function (used in the form Func TRAITEMENT.NOM, or TRAITEMENT is the name of the process, where NOM is the name of the process). The function must be defined previously in the sub-program dictionary.

It should be noted that it is possible to define a list of fields that can be used irrespective of the context and/or a list for a given functional context.

    Prerequisite

    SEEREFERTTO Refer to documentation Implementation

    Screen management

    Entry screen

    Presentation

    A single screen is used to identify the context and the header field type. Then the list of fields to be displayed in the formula assistant is entered in a grid.

    Close

     

    Fields

    The following fields are present on this tab :

    Block number 1

    • Type (field TYP)

    This type, identified by local menu 2945, identifies the category for the elements that can be selected from the left list in the formula assistant. These elements are found in the form of a tree structure. The root lines of the tree structure can correspond to one of the categories defined here or with the labels for the tables or the screens on-line.

    Defines the code for the function where the context must be described. This code is mandatory for the local variables.

    Table List of values

    • field COD

    Defines the code for the section accessible in the formula editor. This section can be the name of a variable, or a code for a function in the form TRAITEMENT/FONCTION (process/function).

    • Title (field ZINTIT)

    This explanation label will appear in the formula editor, is used to select the corresponding section.

    Close

     

    Specific Buttons

    The following fields are present on the window opened through this button :

    Block number 1

    • field OBJET

     

    • field CLES

     

    Block number 2

    • From folder (field DOSORG)

    This field is used to define the folder from which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

    • All folders (field TOUDOS)

    This option is used to copy the record to all the folders defined in the dictionary (ADOSSIER table from the current solution).

    • To folder (field DOSDES)

    This field used to define the folder in which the record is going be copied. The possible syntaxes are described in the dedicated appendix.

    Close

    This button is used to copy the record definition from or to another folder.

    Error messages

    In addition to the generic error messages, the following messages can appear during the entry :

    xxxxx : variable not defined

    The global variables that are not system variables must be defined in the global variables dictionary.

    xxxxx : Non existent sub-program

    The functions must all be defined in the functions dictionary. They are identified here in the form process/sub-program.

    This sub-program does not correspond to a function

    Only the functions used in the sub-program dictionary can be entered here.

    Tables used

    SEEREFERTTO Refer to documentation Implementation