A portlet script for a custom reminder in the employee center role. The portlet script will only be available as suiteApp in the employee center. So when it set up by personalizing the dashboard the portlet must be select from suiteApp.
/** *@NApiVersion 2.x *@NScriptType Portlet */ /******************************************************************************* * CLIENTNAME:AQUALIS * AQ-386 * * ************************************************************************** * Date : 28-05-2020 * * Author: Jobin & Jismi IT Services LLP * Script Description : Custom reminder for expense report – pending projrct manager approval * Date created :28-05-2020 * * REVISION HISTORY * * Revision 1.0 ${28-04-2020} Gloria : created * ******************************************************************************/define([‘N/search’], function(search) { function render(params) { var portlet = params.portlet; portlet.title = ‘Reminder’; var expensereportSearchObj = search.create({ type: “expensereport”, filters: [ [“type”,”anyof”,”ExpRept”], “AND”, [“custbody_normal_approve”,”is”,”F”], “AND”, [“mainline”,”is”,”T”], “AND”, [“custbody_status”,”anyof”,”1″], “AND”, [“formulatext: DECODE(REPLACE({custbody_project_manager},REPLACE({custbody_project_manager}, {user.entityid}, ”),”), {user.entityid},’T’,’F’)”,”is”,”T”] ], columns: [ search.createColumn({ name: “tranid”, summary: “COUNT”, label: “Document Number” }), search.createColumn({ name: “fxamount”, summary: “COUNT”, label: “Amount (Foreign Currency)” }), search.createColumn({ name: “custbody_project_manager”, summary: “COUNT”, label: “Project Manager” }) ] }); var searchResultCount = expensereportSearchObj.runPaged().count; log.debug(“expensereportSearchObj result count”,searchResultCount); var count=0; expensereportSearchObj.run().each(function(result){ // .run().each has a limit of 4,000 results count=result.getValue({ name: “tranid”, summary: “COUNT”, label: “Document Number” }); return true; }); var content = ‘<table><tr><th><h4 style=”font-size:16px;”><b>’+count+'</b></h4></th></tr><tr><td><a href=”/app/site/hosting/scriptlet.nl?script=519&deploy=1″><b>Expense report – Pending Project manager approval</b></td></tr></table>’; params.portlet.html = content; } return { render: render }; });