I am doing a search on Purchase orders and trying ...
# suitescripts
Scot Sunnergren
02/01/2024, 8:11 PMI am doing a search on Purchase orders and trying to get the vendor id and name. but the two join columns are pulling nothing. Can anyone shed some light regarding the last 2 columns?
var purchaseorderSearchObj = search.create({type: "purchaseorder",filters:[["type","anyof","PurchOrd"],"AND",["mainline","is","T"]],columns:[search.createColumn({name: "datecreated", sort: search.Sort.DESC, label: "Date Created"}),search.createColumn({name: "tranid", label: "Document Number"}),search.createColumn({name: "entity", label: "Name"}),search.createColumn({name: "statusref", label: "Status"}),search.createColumn({name: "amount", label: "Amount"}),search.createColumn({name: "createdfrom", label: "Created From"}),search.createColumn({name: "lastmodifieddate"}),search.createColumn({name: "entityid", join: "vendor", label: "ID"}),search.createColumn({name: "altname", join: "vendor", label: "Name"})]});r
reptar
02/01/2024, 9:11 PMLooks correct. Perhaps you are sending invalid JSON to
SearchResult.getValue()reptar
02/01/2024, 9:15 PMresult.getValue({name: 'entityid', join: 'vendor'})s
Scot Sunnergren
02/01/2024, 9:18 PMBINGO! I did not know I needed the join on the result.
Thank you SO much!
👍 1
l
leo_ns
02/01/2024, 10:56 PMthere's a tool that can take a saved search in UI into code.
leo_ns
02/01/2024, 10:56 PMs
Scot Sunnergren
02/01/2024, 10:57 PMThat is what I use. But it only shows the search and not the assignment of the retrieved values to variables.
l
leo_ns
02/01/2024, 10:57 PMi see.
s
Scot Sunnergren
02/01/2024, 11:00 PM...but it is a very handy add-on
✅ 1
y
yagyakumarnag
02/02/2024, 6:07 PMSeems joined is incorrect. Make changes like as below and try
result.getValue({name: 'altname', join: 'entity'})
r
reptar
02/02/2024, 6:36 PM@yagyakumarnag searches use the transaction table of the records browser, not the field listing from the PO table. notice how the PO table does not have joins, and directs you to the Transaction table for searches.
11 Views