Create a Data Set and Add Parameters to It

2 minutes to read Download PDF Edit

Description

This section describes how to create a data set and add parameters to it.

Instructions

If it does not exist yet, create the data set. If you do not know how to add documents to your project, please refer to this article.

Open the Data Set menu by double-clicking on the data set in the Project Explorer.

At ‘Name’ you can change the name of the data set, whereas at ‘Description’ you can optionally enter text describing the purpose of the data set.

At ‘Source’ you can choose the source of the data set, which has to be either an OQL Query or a Java action.

If you chose to use a Java action as source, you have to specify the columns of the data set and their type. When you deploy your project, a Java action will be generated which you can edit using Eclipse.

You can press the ‘New’ button to bring up a window allowing you to add new columns to the data set. For more information on configuring Java actions using Eclipse, please refer to this article.

If you chose to use an OQL statement as source, enter this statement in the ‘Source’ area.

The statement in the screenshot looks up ‘Order’ objects and defines ‘Number’, ‘Status’ and ‘OrderPrice’ as columns of the data set. The ‘Where’ clause allows for filtering of the data set based on parameters, in this case ‘OrderNumber’ and ‘OrderStatus’. Currently errors are shown since the parameters have not been added to the data set yet, something which will be done in the next step.

In the ‘Parameter’ section of the menu, press the ‘New’ button to add a parameter to the data set.

In the new menu, enter a name for the parameter, choose its type and the object or variable you want to filter or constrain by. Depending on the type of parameter you will then be able to enter ranges or XPath constraints to filter the data.

Make sure all parameters from the OQL statement are added to the data set.

Copyright © Mendix. All rights reserved. | Mendix.com | Terms of Use | Privacy Policy