Forum Discussion

bcole's avatar
bcole
New Contributor
3 years ago

Evaluating an array value that's nested in a Group By Field and Routing the Group By Level based on Array value

I have created a Group By Field on an Order Number. Underneath that order number I have an array of AI_Status values. I would like to assess the entire array if any of the AI_Status values with the...
expression_language
sample_pipeline
alex_panganiban's avatar
alex_panganiban
Contributor
3 years ago
Copy LinkReport

I am an admin in my own, but our organization uses SSO to sign in to the platform. Because of this, I don’t really have access to what my password would be. What would be the best resolution for a scenario like this?

  • bcole's avatar
    bcole
    New Contributor
    3 years ago
    Copy LinkReport

    Hi Bojan,

    I think I figured it out. Perhaps the diagram below can show you what I was asking. I wanted to pull data from one early snap and get that information back way further down the pipeline.

    I needed to join some of my original data from the first SQL Server JSON response with Data from my SQL Store Procedure call: I was asking for the preferred way of making that happen. Below is what I came up with. Unless you have a better idea, I think we can consider the case closed.

    The expression you sent was great, but how would I know to use the “match” with the filtering. I have taken your Expression training class, but I would like to know another resource that can help me learn to create all the complicated Expressions I will need going forward. Also I tried using jsonPath to reach a solution. Some of the jsonPath would work on online validators, but would not inside various snaps.

    Where do you point people to learn the brand of jsonPath that works here?