This example is to create an API which list the components of a structure and select the minimum value of status of these components.
Step 1 : Create a view and a sorting order to have the selection
CMS010 - Information Browser Categories
Select the Master Table where to do the sorting. Then go to View (associated / Ctrl+22) to create a new view.
CRS020 - View : Copy an existing view or create a new one from scratch
CRS016 - View Select Columns : Change the view as desired : rename, select columns and the aggregation display rules
(in the example : select 22 = lowest value in STAT)
Select in Sorting Order : ALL to be visible in all sorting orders
Go back to CMS010 to create a sorting order
CRS022 - Sorting order : duplicate a sorting order to create the new one
Aggregation control allows to "sum" the lines to one result. in this case, aggregation "Facility, Product" allows to have one result per product
next page select the view for this sorting order
Step 2 : Create the API
CMS015 - Custom List MI
Create the API with the verb name (ex : LstStatCompo) & +
Enter the description / name and select the info browser category created previously
=> next
Select the sorting order and the view created previously and the aggregation mode "Facility/Product" to have one result per product.
Validate then Update MI repository to activate the API.
Test the API using Simulation :
Step 3 : refresh the API Gateway
In ION, select API GATEWAY, then API METADATA and Resfresh