Hi all
I have written a custom portlet script to give me a list of opportunities, which appears to be giving me the correct results, apart from one slight issue. For the Company and Sales Rep columns in my results, I am being presented with the internal ID rather than the entity number/customer name and the sales rep name. I need the equivalent of a nlapiGetFieldText() API but for this custom portlet.
This is my current script:
function unqtdOppPortlet(portlet, column) { portlet.setTitle("Unquoted Opportunities"); portlet.addColumn('trandate','date', 'Date', 'LEFT'); var col = portlet.addColumn('tranid','text', 'Number', 'LEFT'); col.setURL(nlapiResolveURL('RECORD','opportunity')); col.addParamToURL('id','id', true); portlet.addColumn('entity','text', 'Customer', 'LEFT'); portlet.addColumn('custbody_pqc_date','date', 'Date of Pre-quote', 'LEFT'); portlet.addColumn('expectedclosedate','date', 'Expected Close', 'LEFT'); portlet.addColumn('projectedamount','currency', 'Projected Total', 'RIGHT'); portlet.addColumn('custbody_opp_site_adress','text', 'Site Address', 'LEFT'); portlet.addColumn('salesrep','text', 'Sales Rep', 'LEFT'); var returnFilter = new Array(); returnFilter[0] = new nlobjSearchFilter('salesrep',null,'is',29918) var returncols = new Array(); returncols[0] = new nlobjSearchColumn('trandate'); returncols[1] = new nlobjSearchColumn('tranid'); returncols[2] = new nlobjSearchColumn('entity'); returncols[3] = new nlobjSearchColumn('custbody_pqc_date'); returncols[4] = new nlobjSearchColumn('expectedclosedate'); returncols[5] = new nlobjSearchColumn('projectedamount'); returncols[6] = new nlobjSearchColumn('custbody_opp_site_adress'); returncols[7] = new nlobjSearchColumn('salesrep'); var results = nlapiSearchRecord('opportunity', null, returnFilter, returncols); for ( var i = 0; i < Math.min((column != 2 ? 5 : 15 ),results.length); i++ ) portlet.addRow( results[i] ) } I think I am making a basic error and hope someone can point me in the right direction!Many thanks in advancePeter