2 Replies Latest reply on Oct 5, 2020 12:14 AM by Ruben Grau Gutierrez

    Provisioning - Problem relationing several tables

    Ruben Grau Gutierrez New Member

      Hello,

      I tried to create a REST service in Provisioning but I'm not sure if I it's possible to do what I think. On the other side will be a Java application which will send required parameters.

       

      I need to return a list of customer that belong to a specific center passed via parameter.

       

      There are these tables involved and the order to connect them is the following:

       

      1- BO_CENTER: Centers

      2- BO_REL_CENTER_REQUEST: Relation between centers and requests.

      3- BO_REQUEST: Request asked by customer

      4- BO_REL_CUSTOMER_REQUEST: Relation between customers and their requests.

      5- BO_CUSTOMER: Customers who do requests.

       

      The issue is that I need to filter first in BO_CENTER for specific centerId then go to BO_REL_CENTER_REQUEST to get the requestID, then go to BO_REL_CUSTOMER_REQUEST filter by the requestID to get the customerID and then go to BO_CUSTOMER to get customer details.

       

      Is is possible to do that? Obviously these tables have relationships created in MDM, there are the following FK:

       

      BO_REL_CENTER_REQUEST to BO_CENTER

      BO_REL_CENTER_REQUEST to BO_REQUEST

      BO_REL_CUSTOMER_REQUEST to BO_REQUEST

      BO_REL_CUSTOMER_REQUEST to BO_CUSTOMER

       

      Am not able to display columns even from the second table, only from the first one.

       

      Can you help me?