The Shared Expression Editor contains the following sections:

• Treeview: The existing expressions are listed in the treeview on the left of the form.
• General Information: The Code and descriptions of the Shared Expression are listed at the top of the form.
• Shared Expression text box. The expression is created and displayed in the text box in the center of the form.
  There is an Evaluate section for testing the expression.
  The Context is used for adding the entity in which the expression
• Used In: When you select an expression, it is displayed in the Expression Editor. The attributes and entities where the expression is used are listed in the Used In section at the bottom of the form.

Shared Expressions can be defined by year. However, the Shared Expression Editor form is not year-based.

Creating a New Shared Expression

To create a new Shared Expression:

1. Launch GNA.
2. Select Editors > Shared Expression Editor.
3. Click New.
4. Enter a code in the Code parameter to identify the Shared Expression.
   This can be any combination of alphanumeric characters and the underscore. It must start with a letter.
   This is a required field.
5. Enter descriptions in the Short and Long English and French Description parameters.
6. Enter the expression in the Shared Expression text box.
   This is a required field.
7. Select an entity for the expression from the Context drop-down list.
   This is an optional field.
8. Select By Year if the expression is specific to one or more years.
9. Select By Jurisdiction if the expression is specific to one or more jurisdictions.
10. Click Save.

Setting Up Expressions By Year / Jurisdiction

To set up expressions by year and / or jurisdiction:

1. Select the By Year and / or By Jurisdiction option on the Shared Expression Editor.
2. The Values by Year/Jurisdiction text box opens.
3. Click the Add icon to add the years and jurisdictions.
4. Additional Jurisdiction and Year text boxes are enabled.
5. Select a jurisdiction from the Jurisdiction drop-down list.
6. Enter a year in Year text box.
7. Click Save.

Using Attributes in an Expression

If you want to add an attribute to an expression,
You can specify an entity for the expression. If you do this, the entity must be included in the form where the expression is used.
To specify an entity:

1. Open the required expression in the Shared Expression Editor.
2. Select the entity from the Context drop-down box.
3. Click Save.

Expressions are listed by Code and Short Description in the Context text box.

Evaluating the Expression

Like the Expression Selector, the Shared Expression Editor has Evaluation functionality.
To verify your expression:

1. Enter your expression in the Shared Expression text box.
2. If any parameters appear on the Editor, enter values in the Parameters text boxes.
3. Click the Execute button.
4. One of the following occurs:
5. If the expression is valid, the results are displayed in the Result text box.
6. If the expression is not valid, an error message is displayed in the Result text box.
7. Click Save to save the expression.

Convert Null Parameters to Default Values

Select this option to convert the Null parameters in the database to default values. This option is selected by default. It is used to facilitate the computation. However, for some expressions, it is better to disable this option. You can test the expression using the Evaluate feature and view the difference between enabling and disabling this option.

Adding the Expression to a GNA Form

Prerequisites

• The expression must be created in the Shared Expression Editor.
  After creating the expression, you need to close GNA.

Adding the Shared Expression to an Administration FormYou can add the same shared expression to multiple forms in GNA, as well as user forms.For example, you may want to make multiple Mass Appraisal codes required when the Total Value of the property exceeds $1,000,000.00.
To add a shared expression to an administrative form in GNA.

1. Launch GNA.
2. Open the first form to which you want to add the expression.
   For example, open the Mass Appraisal Income Overall Adjustments table.
   Mass Appraisal > Table Maintenance > Single Entry Tables > inc – Income Adjustment
3. Click the ellipsis button beside the Is Required field.
4. This opens the Expression Selector.
5. Select the Shared Expression from the Expression drop-down list.
6. The expression is not displayed in the Expression Editor and it cannot be evaluated.
7. Click OK.

Adding a Shared Expression to a Govern Form

You can add a Shared Expression to a Govern user form in the OpenForms Designer. For example, you may want to use the expression that you added to several MA Income tables to enable the Rent Summary group box on the CAMA Income form for buildings with a total value exceeding $1,000,000.00.
To add a Shared Expression to a Govern form:

1. Launch the Govern OFD.
2. Open the required form.
   For example, open the CAMA Income Information form.
3. Select a groupbox or add a label to create an expression.
   For example, select the Rent Summary groupbox.
4. Click the ellipsis button beside a parameter.
   For example, click the ellipsis button beside the Is Enabled parameter.
   This opens the Expression Selector.
5. Select the shared expression from the Expression drop-down list.
6. The expression does not appear in the Expression Editor.
7. Click OK. on the Expression Selector.
8. Click Save on the OpenForms Designer.

See Also

Related Information

• Expression