| Button | Description |
|---|---|
| View inquiry | Displays the inquiry defined by or selected on the window. |
| Element | Description |
|---|---|
| Inquiry title | The title to be used for the inquiry window. Type a name to add a new inquiry or select an inquiry for editing from the list of existing inquiries. |
| Sitemap title | The name of the inquiry window as it will be displayed on the sitemap. You can enter any name by using alphabetic or numeric characters. You must specify the sitemap title if you want to replace a entry window with this inquiry window. |
| Location in the menu | The location of the new inquiry window on the sitemap. You can select a required location manually. You must specify the sitemap location if you want to replace an entry window with this inquiry window. |
| Window ID | The ID of the inquiry window. |
| Arrange parameters in x columns | The number of columns in which the elements for parameters should be arranged in the parameters area of the inquiry window. |
| Select top x records | The maximum number of records to be displayed as results. |
| Records per page | The maximum number of records to be displayed on the page. |
| Export top x records |
| Column | Description |
|---|---|
| Table name | The name of the table or DAC that provides access to database tables. You can select a table from the list of available tables (DACs). |
| Alias | The alias to be used in SQL statements to designate the table. If no alias is specified, the Table name is used. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the record is active and is used to specify relations. |
| Parent table | The name (alias) of the first table in a JOIN statement of SQL. |
| Join type | The type of JOIN between participating tables or DACs, which can be one of the following options:
You can concatenate multiple joining conditions between different parent tables to the same child table into one ON clause. For example, if you cross join Custom week and Employees, you can also join time cards that exist for the Custom week-Employees pairs. |
| Child table | The second table to be used in the JOIN statement. |
| Element | Description |
|---|---|
| Brackets | The opening bracket or brackets for composing a logical expression with multiple conditions. |
| Parent field | The field from the parent table. Click the  icon to select a field, or click the  icon to open the Formula editor dialog box and create a formula. |
| Condition | One of the following logical conditions:
|
| Child field | The field from the second table. Click the icon to select a field, or click the icon to open the Formula editor dialog box and create a formula. |
| Brackets | The closing bracket or brackets for composing a logical expression with multiple conditions. |
| Operator | The logical operator between conditions, which can be And or Or. |
| Button | Description |
|---|---|
| Move row up | Moves the selected row up by one row. |
| Move row down | Moves the selected row down by one row. |
| Combo box values | Brings up the Combo box values dialog box, which you can use to enter the options to be used for the drop-down list of options for this parameter. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the parameter is active and will be added to the inquiry area that provides fields for inquiry parameters. |
| Is required | A check box that indicates (if selected) that this field is required in the inquiry window. |
| Name | The name of the parameter. |
| Schema field | An optional field indicating the database field selected as the schema for this field. If no field is specified, the parameter field will be a simple data input field. |
| Display name | The name for the field to be displayed in the window. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| From schema | A check box that indicates (if selected) that the field will be based on (copied from) the schema field. |
| Default value | The default value of the field. For the data fields of the date type that are based on schema fields (that is, the From schema check box is selected), you can select one of the following date-relative parameters in the Calendar dialog box:
All the date-relative parameters use the date of the server used to run the Visma Net instance as the current date. Additionally, you can modify the date-relative parameters by adding or subtracting integers. The unit of measure of the parameter is determined automatically and the reference point is moved according to the measurement of the parameter, for example, @WeekStart+1 relate to the start of the next week. |
| Column span | The number of columns in the parameters area in the inquiry window this column will span. |
| Control size | The size that represents the height and width of the control in pixels. |
| Column width | The width of the grid column. |
| Field size | The size of the field in the inquiry. Options between XXS and XL. |
| Hidden | When this check box is selected, the field is hidden in the inquiry. |
| Label size | The size of the label in the inquiry. Options between XXS and XL. |
| Element | Description |
|---|---|
| Value | The value assigned to an option to be added to the combo-box list. |
| Label | A text string to be displayed as an option. |
| OK (button) | Saves the combo-box options for the parameter. |
| Button | Description |
|---|---|
| Move row up | Moves the selected row up by one position. |
| Move row down | Moves the selected row down by one position. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the row is an active condition. |
| Brackets | The opening bracket or brackets for composing a logical expression with multiple conditions. |
| Data field | The field whose value the condition should be applied to. |
| Condition | One of the following logical conditions, which will be applied to the value of the field specified as the Data field and the values in the Value 1 and Value 2 fields if applicable:
If you try to filter the inquiry results by using a string with the underscore, the result will also contain the values with the same string with any symbol instead of the underscore. For example, if you try to filter the inquiry by a customer name that contains the Customer_Name string, the system will return all the customers whose name contains any of the following strings: Customer_Name, Customer-Name, and Customer Name. The reason that all of these strings will be returned is that the underscore is used as a wildcard character. |
| From schema | A check box that indicates (if selected) that Value 1 will display the specified data field’s options in the system. |
| Value 1 | The value to be used in the selected condition.
Click the For the date-related data fields you can use the date-relative parameters either by selecting the parameter in the Calendar dialog box (if the field is based on a schema field and the From schema check box is selected) or by using the date-relative parameter in a formula (if the field is not based on a schema field and you use the formula editor). The following date-relative parameters are available:
All the date-relative parameters use the date (in UTC) of the server used to run the Visma Net instance as the current date. Additionally, you can modify the date-relative parameters by adding or subtracting integers. The unit of measure of the parameter is determined automatically and the reference point is moved according to the measurement of the parameter, for example, @WeekStart+1 relate to the start of the next week. |
| Value 2 | The second value to be used, if the selected condition requires
one.
Click the For the date-related data fields that are not based on a schema field (that is, the From schema check box is cleared), you can use one of the date-relative parameters, as described in Value1. |
| Brackets | The opening bracket or brackets for composing a logical expression with multiple conditions. |
| Operator | The logical operator to join conditions in a logical expression, which can be And or Or. |
| Button | Description |
|---|---|
| Move row up | Moves the selected row up by one position. |
| Move row down | Moves the selected row down by one position. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the row is active and is used in grouping the inquiry results. |
| Data field | The field whose value the grouping should be applied to. You cannot select the attribute fields as a value of this column. In the entry and maintenance window of a class, the attribute fields are listed on the Attributes tab. |
| Button | Description |
|---|---|
| Move row up | Moves the selected row up by one position. |
| Move row down | Moves the selected row down by one position. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the row is active and is used in sorting the inquiry results. |
| Data field | The name of the field in the inquiry window. |
| Sort order | An option describing how values should be ordered in this column: in Ascending or Descending order. |
| Button | Description |
|---|---|
| Up | Moves the selected row up by one row. |
| Down | Moves the selected row down by one row. |
| Column | Description |
|---|---|
| Active | A check box that indicates (if selected) that the row is active and thus is used in selecting the results. |
| Object | The name (alias) of the table. |
| Data field | The field of the table or the formula that includes fields and constants.
Click the
icon to select a
field, or click the icon to open the
Formula editor dialog box and create a formula. |
| Schema field | The field to be used as the source of properties for this field. |
| Width (pixels) | The width of the grid column in pixels. |
| Visible | A check box that indicates (if selected) that this field will appear in the resulting grid. If the check box is cleared, the field will be hidden by default but can be added to the grid by a user. |
| Default navigation | A check box that indicates (if selected, which is the default value) that the field value can be a link to the default window, which the user can open by clicking the link, specified in the source code. For example: For the field that holds the invoice reference number, the default window is the Sales invoices (AR301000) window. If the check box is cleared, the field value can be a link to the window selected in the Navigate to field. If the Default navigation check box and the Navigate to field are cleared, the field cannot be a link. If you select the Default navigation check box, you should clear the Navigate to field. |
| Navigate to | A window specified on the Navigation tab that the user can open by clicking the link in the column. If you select any window in the field, the Default navigation check box is cleared automatically. |
| Aggregate function | A function that defines how the resulting value should be calculated for the grouped values in this column. The following aggregate functions are available:
The following aggregate functions are applied by default, when no function is selected:
|
| Caption | The name for the column header to be displayed in the window. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Quick filter | A check box that indicates (if selected) that the system should add a button with the quick filter for this field to the filtering area of the generic inquiry form. If multiple tabs are displayed on this generic inquiry form, the button with the quick filter is added to the filtering area of the All records tab. By default, this check box is cleared. |
| Element | Description |
|---|---|
| Entry window | The entry window to be associated with this inquiry. The list of available windows is filtered according to the data access classes selected for the inquiry on the Tables tab. When you select an entry window, this window is added to the Navigation tab automatically. The navigation parameters, which are the key fields in the entry window and the inquiry parameters that should be passed to these fields, are filled in automatically, but you can also specify these parameters manually. |
| Replace entry window with this inquiry in menu | A check box you select to replace the entry window selected in the Entry window column with the inquiry (that is, to display the inquiry instead of the entry window when the user clicks the menu item in the navigation pane). |
| Element | Description |
|---|---|
| Enable mass actions for records | A check box that you select to allow users to perform the actions you select on the records in the inquiry window. With this check box selected, the Mass actions tab appears in this window. On this tab, you can specify the action or actions that will be available in the Actions menu in the window toolbar of the inquiry window. If this box is selected, the selected commands will appear in the Actions menu in the window toolbar and the Selected column in the table of the substitute window. A user can select one record or multiple records, and then apply any available command to the selected records. |
| Automatically confirm customized mass actions | This check box and the Enable mass actions for record must both be selected, in order to make the system confirm automatically any confirmation dialog pop-up that would be raised by the system while executing the action. |
| Enable mass deletion | A check box you select to allow users to delete multiple records from the list in the inquiry window. If this check box is selected, the Delete button appears in the window toolbar and the Selected column appears in the inquiry window. A user can select one or multiple records, and then delete them. |
| Automatically confirm customized mass deletion | This check box and the Enable mass record deletion must both be selected, in order to have the system automatically confirm the deletion of records when a user clicks Delete. |
| Enable mass update | A check box that you select to allow users to update multiple records from the list in the inquiry window. If you select this check box, the Mass update fields tab appears in the window. Use this tab to select the field (or fields) that users should be able to update. If this check box is selected, the Update and Update all commands appear in the Actions menu in the window toolbar and the Selected column in the table of the inquiry window. A user can select one record or multiple records, and then change the specified fields of the selected records. |
| Enable new creation | A check box you select to allow users to create new records from the inquiry window. If this check box is selected, the Add record button appears in the window toolbar in the table of the inquiry window. When a user clicks the button, the entry window opens so the user can add a new record. |
| Column | Description |
|---|---|
| Field | The name of the field in the entry window. |
| Value | The default value for the selected field. |
| Column | Description |
|---|---|
| Field | The name of the field of the window, which can be the field in the entry window, the inquiry parameter, or the report parameter. |
| Parameter | The default value for the selected field. |
| Element | Description |
|---|---|
| Window mode | The way the window is opened. The following modes are available:
For more information, see: If the window is selected as the entry window on the Entry point tab and replaced with the inquiry, the window mode of this window is Inline. This means that this window opens in the same browser tab when a user is adding a new record or viewing the details of an existing record. You cannot change this mode. |
| Column | Description |
|---|---|
| Select | An unlabelled check box that you use to select the fields you want to be updated. When you add a field to this table, it becomes active, with the Select check box automatically selected. You can clear the check box any time. |
| Field name | The name of the field that should be updated. |
| Column | Description |
|---|---|
| Select | An unlabelled check box that you use to select an action. When you add an action to this table, it becomes active, with the Select check box automatically selected. You can clear this check box any time. |
| Action | The name of the action that will be available in the Actions menu in the window toolbar of the inquiry. |