You can add a control of type Configurable grid to a form.

To fill the configurable grid, a query is required. Compared to the Data grid control, you can configure the required query for the Configurable grid. So, no coding is required.
You must also configure the configurable grid columns.
If your company uses different types of mobile devices, controls can require a different layout for each device.


Designer Designer Developer Developer Start Start To define a range,  is a condition required  that uses a function  other than the  predefined functi To define a range,  is a condition required  that uses a function  other than the  predefined functi Inform the developer on the  function class to be developed Inform the developer on the  function class to be developed Develop function class Develop function class You can use a function to fill the related value of a condition.You can use function for a condition on:An event procedure action.A query range or a configurable grid query range. For a function, a class is required. To develop this class, extend the DAWFunctionRun class. Prerequisite: Develop the extension of the DAWFunctionRun class in the AOT before you start the steps.Note: The steps are to have the developed function class uploaded as function to the related library. Procedure 1. Click Mobility design. 2. Click the Libraries tab. 3. In the list, find and select the desired record. 4. Click View. 5. Click the Functions tab. 6. Click Refresh. 7. Close the page. Notes If you deploy (export/import) an application as built in Mobility studio, make sure the related custom function classes are deployed as well. You can do so with a Microsoft Dynamics Lifecycle Services project. Inform the designer that  the function class is  available in the library Inform the designer that  the function class is  available in the library Is a query required  other than the  predefined queries? Is a query required  other than the  predefined queries? Create query Create query You can use a query to get the relevant data:To be shown in a configurable grid.For the predefined 'Query' action that is used on an event procedure.For a counter.To configure a query, you can use the Create query wizard. Procedure 1. Click Mobility design. 2. Click Create query. 3. Sub-task: Define the basic settings for the query. 4. In the Query field, type a value. 5. In the Application field, enter or select a value. 6. In the Number of records to show in preview field, enter a number. 7. Select Yes in the Select only first record field. 8. Select Yes in the Allow cross company field. 9. Click Next. 10. Sub-task: Select the applicable tables for the query. 11. In the Tables pane, select the tables to be added to the query. Note: You can select and add several tables in one go. The root table of the query always must be at the top of the list of selected tables. To make sure this is the case, you are advised to first select and add the root table. Then you can select and add other required tables in one go. 12. Click >. 13. Except for the root table, for all tables you must define the parent table. In the Parent field, enter or select a value. Note: You can only select a table as parent if it is also in the table selection of the query. 14. Click Next. 15. Sub-task: Review or add table relations. 16. In the left pane, find and select the desired child table. 17. Click Add. 18. In the Child field field, enter or select a field from the child table. 19. In the Parent field field, enter or select the related field from the parent table. Note: For each relation, you can define the relation settings: Query fetch mode, JOIN type, Level. 20. Click Next. 21. Sub-task: Select the fields to be shown for the query. 22. In the left pane, find and select the desired table. 23. In the Select query fields pane, find and select the desired fields to be added to the query. 24. Click >. Note: You can use the Up and Down buttons to arrange the fields in the desired sequence. 25. Select the Group by check box. 26. In the Aggregate field, select an option. 27. To review the query results in the preview, click Refresh. 28. Click Next. 29. Sub-task: Define ranges for the query. 30. In the left pane, find and select the desired table. 31. In the middle pane, find and select the fields for which you want to add a range. 32. Click >. 33. In the Condition field, select an option. 34. For each added field, set the value for the condition. To set the value, you can use a variable, a function, or a fixed value. In the Value field, enter or select a value. Note: You can only use variables and functions that are applicable for the application to which the query is assigned. 35. To review the query results in the preview, click Refresh. 36. Click Finish. Notes A query is application specific. You can view the available application queries in several ways, for example on the Queries tab of the Mobility design workspace. Update application libraries Update application libraries In your application design, you can only use the libraries and library elements that are linked to the application. An application library defines which library elements can be used in the application design. Library elements are: actions, functions, and data sets.You link libraries to an application in several ways:Add manuallyYou manually add a library to an application to make it available for use in the application.Link automaticallyIf you have imported an application, the used libraries are not linked automatically. To make the used libraries available for the application, you must link these. Only the libraries are linked of which at least one action, function, or data set is used in the application.Note: If you link libraries, and an already linked library is not used in the application, it is removed from the linked libraries.If a linked library is updated, for example a new action class is created, you must refresh the libraries to have the updates available for the application. To do so refer to: Manage libraries. Procedure 1. Click Mobility design. 2. On the Applications tab, click Edit. 3. Click the Libraries tab. 4. Sub-task: Manually add library to application. 5. Click Add. 6. In the Library field, enter or select a value. 7. Click Save. Note: As a result, all current actions, functions, and data sets of the library are added to the application. 8. Sub-task: Link used libraries to application. 9. If you have imported an application, you must link the used libraries to the application. Click Link libraries. Note: You can also use this to clean up the list of linked application libraries. The libraries that are not used in the application, are removed from the linked libraries list. 10. Close the page. Create form control - Configurable grid Create form control - Configurable grid You can add a control of type Configurable grid to a form.Compared to the data grid, a configurable grid uses a configurable query to query the data. Procedure 1. Click Mobility design. 2. Click the Forms tab. 3. In the list, find and select the desired record. 4. Click Edit. 5. If you add a control, it is positioned before the selected control on the form. On the preview, select the desired control. Note: If the control list is shown instead of the preview, in the list, find and select the desired control. 6. On the Properties tab, click Add. 7. Click Configurable grid. 8. Sub-task: Define control properties. 9. In the Control field, type the configurable grid name. Note: Only use letters and numbers, no spaces. 10. You can use an index to indicate which row in the grid must be selected when the grid is shown on a mobile device. In the Selected index field, enter a number. Note: Index numbering starts from 0. So, if the index is 0, the first row is selected. 11. If you want to hide the configurable grid on the form, select No in the Visible field. 12. If the configurable grid must be unavailable on the form, select Yes in the Read-only field. As a result, the configurable grid appears dimmed. 13. If the next control must be positioned on a new line, select Yes in the Append new line field. 14. To link a form variable, in the Linked variable form field, enter or select the current form. 15. You can link an application variable or a form variable to the check box. In the Linked variable name field, enter or select a value. Note: Make sure, the extended data type of the variable has the same type as the control. 16. In the Preview value field, type the example values. 17. In the Query field, enter or select a value. 18. In the Documentation section, write the configurable grid control documentation. For example, describe the purpose and characteristics of the configurable grid control. 19. To show the added control on the preview, on the Design tab, click Refresh. Notes In general, if you add a form control, it is positioned before the selected control on the form.Where the control is exactly positioned on the preview, also depends on:The Append new line property of the previous control and of the added control.The preview style sheet.You can use the Up and Down buttons on the Properties tab to move a form control to another position on the form. Configure grid Configure grid Configure the columns of the configurable grid and the data that is shown in the configurable grid. The related query defines which columns are available for the grid. Procedure 1. Click Mobility design. 2. Click the Forms tab. 3. In the list, find and select the desired record. 4. Click Edit. 5. On the Controls tab, in the list, find and select a control of type Configurable grid. 6. On the Details tab, in the Query field, click to follow the link. 7. Sub-task: Add range to query ranges. 8. To make the query results more specific for the configurable grid, you can add a range to the existing query ranges. Click Add. Note: You cannot change or remove ranges that are defined on the query. 9. In the Datasource name field, enter or select a value. 10. In the Table field field, enter or select a value. 11. In the Condition field, select an option. 12. For each added range, set the value for the condition. To set the value, you can use a variable, a function, or a fixed value. In the Value field, enter or select a value. Note: You can only use variables and functions that are applicable for the application to which the query is assigned. 13. To review the query results in the preview, click Refresh. 14. Sub-task: Create grid configuration. 15. Click the Fields tab. 16. Select the query fields that you want to add to the configurable grid. 17. Click Create grid configuration. 18. Sub-task: Configure grid. 19. Click the Grid configuration tab. 20. In the Label field, you can select the label for the display name of the column. Note: If no label exists, you can click Generate labels from text. As a result, for all fields without a label defined, a label is created based on the value in the text field. Before you create labels from text, define the known labels for the fields. 21. In the Width field, define the width of the column expressed in a number of pixels. Note: Enter a width of 0 to hide the column. 22. In the Linked variable name field, enter or select a value. 23. If a variable is defined, the label of the related extended data type can be used as display name for the column. By default, the label of the extended data type is not used. If you want to use the label of the extended data type, select the Get caption from extended data type check box. Note: If you use the label of the extended data type, do not fill in the Label. Is a  device-specific  control layout  required? Is a  device-specific  control layout  required? Make control layout device-specific Make control layout device-specific If your company uses different types of mobile devices, controls can require a different layout. For example, longer labels do not fit properly on a smaller screen. So, you can define a smaller version of such a label for these small-screen mobile devices. Procedure 1. Click Mobility design. 2. Click the Forms tab. 3. In the list, find and select the desired record. 4. Click Edit. 5. On the preview, click the desired control. Note: If the control list is shown instead of the preview, in the list, find and select the desired control. 6. Click the Device/localized specific tab. 7. Click Add and fill in the fields. 8. Close the page. End End Yes No Yes No No Yes

Activities

Name Responsible Description

Develop function class

Developer

You can use a function to fill the related value of a condition.
You can use function for a condition on:
  • An event procedure action.
  • A query range or a configurable grid query range.
For a function, a class is required. To develop this class, extend the DAWFunctionRun class.
Prerequisite: Develop the extension of the DAWFunctionRun class in the AOT before you start the steps.
Note: The steps are to have the developed function class uploaded as function to the related library.

Create query

Designer

You can use a query to get the relevant data:
  • To be shown in a configurable grid.
  • For the predefined 'Query' action that is used on an event procedure.
  • For a counter.
To configure a query, you can use the Create query wizard.

Update application libraries

Designer

In your application design, you can only use the libraries and library elements that are linked to the application. An application library defines which library elements can be used in the application design. Library elements are: actions, functions, and data sets.
You link libraries to an application in several ways:
  • Add manually
    You manually add a library to an application to make it available for use in the application.
  • Link automatically
    If you have imported an application, the used libraries are not linked automatically. To make the used libraries available for the application, you must link these. Only the libraries are linked of which at least one action, function, or data set is used in the application.
    Note: If you link libraries, and an already linked library is not used in the application, it is removed from the linked libraries.
If a linked library is updated, for example a new action class is created, you must refresh the libraries to have the updates available for the application. To do so refer to: Manage libraries.

Create form control - Configurable grid

Designer

You can add a control of type Configurable grid to a form.
Compared to the data grid, a configurable grid uses a configurable query to query the data.

Configure grid

Designer

Configure the columns of the configurable grid and the data that is shown in the configurable grid. The related query defines which columns are available for the grid.

Make control layout device-specific

Designer

If your company uses different types of mobile devices, controls can require a different layout. For example, longer labels do not fit properly on a smaller screen. So, you can define a smaller version of such a label for these small-screen mobile devices.

Provide feedback