Forum Discussion

manohar's avatar
manohar
Contributor
3 years ago

Filter grandchild based on value in grandchild field

hi there, I have the attached json message thats coming in this structure shown below. I need to filter the list in the Orderlines array if the status has “soft_closed_for_receiving” or “soft_close...
manohar's avatar
manohar
Contributor
3 years ago

Thank you very much @bojanvelevski.

sorry I was not clear enough.

Step 1. I need to filter out the Lines that have these 2 values. so the result List will have lines that have status other than the 2 values.

Step 2. now route based on if the list count is greater than 0 or if its 0.

any pointers for this.

Thanks
Manohar

bojanvelevski's avatar
bojanvelevski
Valued Contributor
3 years ago

Then the expression will suffer a minor change:

$payload['order-lines'].filter(x=>!(x.status matches "soft_closed_for_receiving" | "soft_closed_for_invoicing")).length > 0

  • manohar's avatar
    manohar
    Contributor
    3 years ago

    Thank you again @bojanvelevski that did the trick.

    I appreciate your help.

    Manohar