Policy Automation for B2C Service

Get Involved. Join the Conversation.


    Scott Heidenreich
    Pull many to many related data into OPA from OSvC
    Topic posted September 24, 2018 by Scott HeidenreichBronze Trophy: 5,000+ Points 
    Pull many to many related data into OPA from OSvC
    How do I pull many to many related data into OPA from OSvC

    I have two Parents related in a many to many relationship with a cross reference table between them. as follows:

    PWS 1-M Xref M-1 Operator

    I can successfully load the date from one table to the next using a condition for each entity.  However, when I try to rely on the relationship from OSvC nothing loads.  It would be far simpler for me to be able to just identify the PWS parent record and let the OSvC relationships pull everything else on down the line, but the Via choice results in nothing coming back, not even from the Xref table, even though it appears to be correctly identifying the correct attributes.

    Via OperatorXPWS$PWS_ID of PWS

    Is there any documentation or tips that you can provide for having OPA load many to many relationships, or do I need to rely on the condition to get the load?

    What about sequential 1-M relationships?  For example, Facility 1 - M Operators 1-M Certificates.

    Is there any way to provide the facility ID number and have all that facilities operators pulled, then all the operator's certificates pulled automatically, or is a condition needed for each entity here also?

    Thank you.