I was wondering if anyone had experience doing fil...
# suitescriptd
David Durst
04/09/2019, 5:17 PMI was wondering if anyone had experience doing filters on sublisted join columns?
b
battk
04/09/2019, 6:08 PMYour question is weird. Sublists are for records. Joins are for searches.
battk
04/09/2019, 6:09 PMWhat are you trying to ask
d
David Durst
04/09/2019, 6:39 PMI am trying to get a search that provides fields from the preferred supplier for a inventory item
b
battk
04/09/2019, 6:41 PMThat should be on the preferred vendor join
d
David Durst
04/09/2019, 6:45 PMyes... but how to actually execute this?
b
battk
04/09/2019, 6:46 PMcreate an item search in the ui
battk
04/09/2019, 6:46 PMadd a column on the results
d
David Durst
04/09/2019, 6:47 PM Copy code
var search = nsSearch.create({
type: nsSearch.Type.INVENTORY_ITEM,
filters: ["itemvendor.preferredvendor", <http://nsSearch.Operator.IS|nsSearch.Operator.IS>, "T"],
columns: ["displayname","itemvendor.vendor_display"]
});b
battk
04/09/2019, 6:47 PMjoins are the ones on the bottom of the select (they have ..., in the name)
battk
04/09/2019, 6:49 PMyou can use the search you created in the script, or you can copy the columns
battk
04/09/2019, 6:58 PMthere is a chrome extension to make this particular flow easier
10 Views