RE: Sublist – filter on 2 fields
From the customer record, I am trying to create a sublist of Sales Orders.
Where
Name = This Customer Record
OR
Project : CustomNameField = This Customer Record
I can easily get a saved search to work by setting the criteria to a specific customer, but I want it to be dynamic such that the search works as a sublist.
Other option I have tried is using a formula to match on a customer internal ID. If I could somehow replace the hardcoded internal ID with a dynamic value from the parent record, or URL, that would work.
I’ve managed to get close with scripting it.
function beforeLoadSublist(type, form)
{
if (type=='edit' || 'view')
{
//add a sublist to the form. Specify an internal ID for the sublist,
//a sublist type, sublist UI label, and the tab the sublist will appear on
var orders = form.addSubList('custpage_openjobs', 'list', 'Open Jobs Test', 'general');
//add fields to the sublist
orders.addField('number', 'text', 'Doc No');
orders.addField('type', 'text', 'Type');
orders.addField('entity', 'text', 'Name');
orders.addField('status', 'text', 'Status');
orders.addField('totalamount', 'text', 'Amount');
// perform a record search. Set search filters and return columns for
// the search
var joblistResults = nlapiSearchRecord('transaction', null,
[
new nlobjSearchFilter('entity', null, 'anyOf', 1349811),
new nlobjSearchFilter('type', null, 'anyOf', 'SalesOrd'),
new nlobjSearchFilter('mainline', null, 'is', 'T')
],
[
new nlobjSearchColumn('number'),
new nlobjSearchColumn('type'),
new nlobjSearchColumn('entity'),
new nlobjSearchColumn('totalamount'),
new nlobjSearchColumn('status')
]
)
orders.setLineItemValues(joblistResults)
}
}
My issue now, is that the resulting sublist for fields like TYPE show SalesOrd – ie the VALUE not the TEXT. So my results look like:
Doc No, Type, Name, Status, Amount
SO1234, SalesOrd, 1349811, fullyBilled, 456.34
SO1235, SalesOrder, 1349811, pendingFulfillment, 2355.22
When what I want in the results is like this:
Doc No, Type, Name, Status, Amount
SO1234, Sales Order, John Smith, Fully Billed, $456.34
SO1235, Sales Order, John Smith, Pending Fulfillment, $2355.22
How do you get a sublist search to return the TEXTS of the values instead of the VALUES
