D365 Finance Operations Query Wizard (Magic xpi 4.14)
The D365 Finance Operations Query Wizard helps you to build D365 Finance Operations queries with the correct syntax, and is available when you select the Get operation in the D365 Finance Operations Configuration dialog box's Operation field.
It contains the following separate screens:
The Where screen lets you define the criterion using which results will be fetched by the query. It contains the following parameters as columns:
-
Field Name: Select the required field name from the drop-down list. The available field names are determined by the entity that you selected in the D365 Finance Operations Configuration dialog box's Entity field.
-
Operator: Select the required operator from the drop-down list. The available operators are determined by the field name that you selected in the Field Name column.
-
<!?Field Name?!>: This read-only column displays the previously selected field name.
Click Add to add lines to the Where query, and click Delete to delete lines from the Where query.
|
|
-
When you add a line, the D365 Finance Operations query is created with 'and' between the created lines. You can manually edit the resulting query as required.
-
When setting the value for the Field Names in the Data Mapper, if the value contains HTTP reserved characters like & and ?, then it should be URL encoded.
For example:
The value "Compensation & Benefits" contains the reserved ampersand (&) character.
The URL encoded value should look like "Compensation%20%26%20Benefits" in the Data Mapper.
|
The Column Selection screen lets you select columns for your query. Select the check box next to the required column(s). The available columns are determined by the entity that you selected in the D365 Finance Operations Configuration dialog box's Entity field.
The Expand screen lets you select additional entities that are related to the entity that you selected in the D365 Finance Operations Configuration dialog box's Entity field.
The Order screen lets you define the order of the results that are fetched by the query. It contains the following parameters as columns:
-
Field Name: Select the required field name from the drop-down list. The available field names are determined by the entity that you selected in the D365 Finance Operations Configuration dialog box's Entity field.
-
Direction: Select the direction of the results order from the drop-down list. The options are Ascending or Descending.
Once you have gone through these screens, click Finish. The D365 Finance Operations Query Wizard will close, and you will then see your newly created query in the D365 Finance Operations Configuration dialog box's Parameters field.
|
|
The D365 Finance Operations Query Options are controlled by the D365 Finance Operations Provider. The Get Metadata call does not retrieve these query options. So all the available options will always be displayed to the user. It is the user's responsibility to use only those query options which are supported by the D365 Finance Operations Provider. Disabling or prohibiting the D365 Finance Operations query options on the Provider side might cause the client call to fail.
For example, if the Expand option is disabled on the Provider side, the user will still be able to select it in the Studio. This will cause the project to fail at runtime. So the user has to be cautious not to select the options which are not supported on the Provider side.
|
