Create a search to show the results based on sales rep’s supervisor is current user

Script

var customrecord_jj_commission_report_phrin6SearchObj = search.create({
   type: "customrecord_jj_commission_report_phrin6",
   filters:
   [
      ["custrecord_jj_approval_status_id","anyof","3"], 
      "AND", 
      ["isinactive","is","F"], 
      "AND", 
      ["custrecord_jj_sales_rep_name.supervisor","anyof","@CURRENT@"]
   ],
   columns:
   [
      search.createColumn({name: "custrecord_jj_commission_year", label: "Year"}),
      search.createColumn({name: "custrecord146", label: "Month"}),
      search.createColumn({name: "custrecord_jj_sales_rep_name", label: "Sales Rep"}),
      search.createColumn({name: "custrecordjj_monthly_quota", label: "Monthly Quota"}),
      search.createColumn({name: "custrecordjj_quota_achived", label: "Monthly Sales Amount"}),
      search.createColumn({name: "custrecord_jj_commission_percentage_get", label: "Commission Percentage"}),
      search.createColumn({name: "custrecord_jj_commisssion_amount", label: "Commission Amount"}),
      search.createColumn({name: "custrecord_jj_new_account_goal", label: "New Account Goal"}),
      search.createColumn({name: "custrecord_jj_new_account_count", label: "New Account Number"}),
      search.createColumn({name: "custrecord_jj_quarter_bonus_amt", label: "Bonus Amount"}),
      search.createColumn({name: "custrecord_jj_approval_status_id", label: "Approval Status"})
   ]
});
var searchResultCount = customrecord_jj_commission_report_phrin6SearchObj.runPaged().count;
log.debug("customrecord_jj_commission_report_phrin6SearchObj result count",searchResultCount);
customrecord_jj_commission_report_phrin6SearchObj.run().each(function(result){
   // .run().each has a limit of 4,000 results
   return true;
});


/*
customrecord_jj_commission_report_phrin6SearchObj.id="customsearch1724645256875";
customrecord_jj_commission_report_phrin6SearchObj.title="Sales Manager Approval - Commission Report Details  (copy)";
var newSearchId = customrecord_jj_commission_report_phrin6SearchObj.save();
*/

Leave a comment

Your email address will not be published. Required fields are marked *