Previous Next JavaScript must be enabled to correctly display this content

## 9.25 Dynamic Data Configuration (DDC)

This topic provides the systematic instructions to perform the basic operations on the selected records.

DDC is an infrastructure component comprising a user interface and a service.

It empowers developers to define prepared statements for dynamic data retrieval. The Dynamic Data Configuration (DDC) service's response is utilized by UI components or invoking services to render List of Values (LOV) results.

Dynamic Data Configuration infra can be utilized with OBX code to call endpoint and bind the response.

Prerequisites:

- For domain services to perform dynamic data queries on the domain schema, the @ComponentScan annotation must include the "oracle.fsgbu.plato.validation" where domain services reside.

  Figure 9-38 Plato Validation

  Description of "Figure 9-38 Plato Validation"
- A database schema created for the Dynamic Data Configuration service.
- A configured JDBC data source named jdbc/PLATODYNADATA on the server.
- Configure newly created schema name in PROPERTIES table of PLATO schema.

Figure 9-39 PLATO schema

Description of "Figure 9-39 PLATO schema"
Deployment Steps:

1. Deploy the Dynamic Data Configuration service to the server.
2. Once deployed, the Dynamic Data Configuration user interface should be accessible.

Configuration steps:

1. Select the desired product processor.
2. Specify the service name.
3. Define the unique key for the data.
4. List the required columns.
5. Provide the from query to retrieve data.
6. Set the paging parameters (if applicable).
7. Determine the desired response format.

Figure 9-40 Dynamic Data Configure

Description of "Figure 9-40 Dynamic Data Configure"
Test Query:

- Test API: Use the test API to execute the query. Provide any necessary query parameters and click "OK." The results will be displayed based on the query.

  Figure 9-41 Modal Dialog

  Description of "Figure 9-41 Modal Dialog"

  Figure 9-42 Success

  Description of "Figure 9-42 Success"
- Test LOV: If applicable, use the test List of Values (LOV) to test the query.

  Figure 9-43 Modal Dialog

  Description of "Figure 9-43 Modal Dialog"

  Figure 9-44 Test LOV

  Description of "Figure 9-44 Test LOV"

Once satisfied with the results, save the dynamic data query.

Parent topic: Extensibility Use Cases for OBX