Forum Discussion

adanmas's avatar
adanmas
New Contributor
9 months ago

Collecting results from pipeline execution snap

I have a simple pipeline that gets called through a trigger that takes multiple documents and calls a child pipeline through a pipeline execution snap. The child pipeline returns if the processing of...
expression_language
j_angelevski's avatar
j_angelevski
Contributor III
5 years ago
Copy LinkReport

@acesario , you can also just add [0] after @viktor_n’s expression.

$Records.map(record => record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length))[0]

And if you really need the “0” you can try and add .map(val => "0" + val)

So full expression is: $Records.map(record => record.Award.map((x, index) => record.Award.slice(0, index + 1).filter(y => y == x).length).map(val => "0" + val))[0]

  • tstack's avatar
    tstack
    Former Employee
    6 years ago
    Copy LinkReport

    Can you provide some more details? Are you building a query in a SQL Execute snap? If you could export and attach your pipeline, that would help us understand what you’re trying to achieve.

    • MadhaviKarri's avatar
      MadhaviKarri
      New Contributor
      6 years ago
      Copy LinkReport

      Hi @tstack

      I have got the issue resolved. This is happening since the APP GAteway firewall is blocking SQL data as in seems like SQL injection.I have handled the data by passing condition as array elements and have appended AND with in snaplogic.