Saved Search formula to filter all the item fulfillment Created in the account

      

The client would like to filter all the item fulfillment that are in shipped status(created through UI or through bulk processing etc)created in the account. We can use the saved search formula as below

letitemfulfillmentSearchObj=search.create({
  type: "itemfulfillment",
  filters: [
    [
      "type",
      "anyof",
      "ItemShip"
    ],
    "AND",
    [
      "item.type",
      "anyof",
      "InvtPart"
    ],
    "AND",
    [
      "custbody_jj_send_email_tsmg72",
      "is",
      "F"
    ],
    "AND",
    [
      "status",
      "anyof",
      "ItemShip:C"
    ],
    "AND",
    [
      "mainline",
      "is",
      "T"
    ],
    "AND",
    [
      [
        [
          "systemnotes.field",
          "anyof",
          "TRANDOC.KSTATUS"
        ],
        "AND",
        [
          "systemnotes.newvalue",
          "is",
          "Shipped"
        ],
        "AND",
        [
          "systemnotes.context",
          "noneof",
          "BLK"
        ],
        "AND",
        [
          "formulanumeric: CASE WHEN {systemnotes.date} BETWEEN TO_DATE(TO_CHAR({today},'YYYY-MM-DD') || ' 17:00:00', 'YYYY-MM-DD HH24:MI:SS') - 1 AND TO_DATE(TO_CHAR({today},'YYYY-MM-DD') || ' 17:00:00', 'YYYY-MM-DD HH24:MI:SS') THEN 1 ELSE 0 END",
          "equalto",
          "1"
        ]
      ],
      "OR",
      [
        [
          "systemnotes.field",
          "noneof",
          "TRANDOC.KSTATUS"
        ],
        "AND",
        [
          "formulanumeric: CASE WHEN {datecreated} BETWEEN TO_DATE(TO_CHAR({today},'YYYY-MM-DD') || ' 17:00:00', 'YYYY-MM-DD HH24:MI:SS') - 1 AND TO_DATE(TO_CHAR({today},'YYYY-MM-DD') || ' 17:00:00', 'YYYY-MM-DD HH24:MI:SS') THEN 1 ELSE 0 END",
          "equalto",
          "1"
        ]
      ]
    ],
    "AND",
    [
      "createdfrom.custbody_notes",
      "is",
      "Split Order"
    ],
    "AND",
    //[
      "item.custitemtmg_program_name",
      "anyof",
      programId
    ],
    [
      "custbody_tmg_program_name",
      "anyof",
      programId
    ],
    "AND",
    [
      "customer.internalid",
      "anyof",
      custId
    ]
  ],
  columns: [
    search.createColumn({
      name: "internalid",
      summary: "GROUP",
      label: "Internal ID"
    }),
    search.createColumn({
      name: "custbody_shopifycustemail",
      join: "createdFrom",
      summary: "MAX",
      label: "Shopify mail id"
    }),
    search.createColumn({
      name: "formuladatetime",
      summary: "MAX",
      formula: "{today}",
      label: "Formula (Date/Time)"
    }),
    search.createColumn({
      name: "formuladatetime",
      summary: "MAX",
      formula: "{today}",
      label: "Formula (Date/Time)"
    })
  ]
});