transactionSearchObj = search.create({
        type: "transaction",
        filters: [
          [
            ["type", "anyof", "Opprtnty", "Estimate", "SalesOrd", "CustInvc"],
            "AND",
            ["subsidiary", "anyof", "13"],
            "AND",
            ["mainline", "is", "F"],
            "AND",
            ["taxline", "is", "F"],
            "AND",
            ["name", "anyof", "30600"],
            "AND",
            ["trandate", "within", "previousoneyear"],
          ],
          "AND",
          [
            ["custbody_loan_number", "startswith", resultObj.query],
            "OR",
            ["custbody_client_order_number", "startswith", resultObj.query],
            "OR",
            ["title", "startswith", resultObj.query],
            "OR",
            ["custbody_r3_ven_order_num", "startswith", resultObj.query],
          ],
        ],
        columns: [
          search.createColumn({
            name: "trandate",
            sort: search.Sort.DESC,
            label: "Date",
          }),
          search.createColumn({
            name: "custbody_loan_number",
            sort: search.Sort.ASC,
            label: "Loan #",
          }),
          search.createColumn({
            name: "formulatext",
            formula:
              "CASE WHEN {type}='Opportunity' THEN 'Vendor Order' WHEN {type}='Estimate' THEN 'Bid' WHEN {type}='Sales Order' THEN 'VCO' WHEN {type}='Invoice' THEN {type} ELSE 'Other' END",
            label: "Type",
          }),
          search.createColumn({
            name: "formulatext",
            formula:
              "CASE WHEN {type}='Opportunity' THEN REPLACE({tranid}, 'OP-RR', '5000') WHEN {type}='Estimate' THEN {custcol_r3_est_bidid} WHEN {type}='Sales Order' THEN REPLACE({tranid}, 'SO-RR') WHEN {type}='Invoice' THEN {custbody_invoice_number_integer} ELSE {tranid} END",
            label: "Number",
          }),
          search.createColumn({ name: "statusref", label: "Status" }),
          search.createColumn({
            name: "custbody_project_status",
            label: "Project Status",
          }),
          search.createColumn({
            name: "formulatext",
            formula:
              "CASE WHEN {otherrefnum} IS NOT NULL THEN {otherrefnum} WHEN {custbody_client_order_number} IS NOT NULL THEN {custbody_client_order_number} WHEN {custbody_r3_bid_plcord_msg_name} IS NOT NULL THEN {custbody_r3_bid_plcord_msg_name} ELSE NULL END",
            label: "Client Order Number",
          }),
          search.createColumn({
            name: "formulatext",
            formula: "NVL({title}, {custbody_est_opp_title})",
            label: "Title",
          }),
          search.createColumn({ name: "internalid", label: "Internal ID" }),
        ],
      });
	  
	  
	  //shows error here
	   transactionArray.push({
        id:
          searchResultLoan[0].getValue(searchResultLoan[0].columns[3]) ||
          searchResultTransactn[0].getValue(
            searchResultTransactn[0].columns[8]
          ) ||
          null}