Is it possible to make a search or suiteQL that fi...
# beginnerse
Eystein Bye
02/17/2021, 7:24 AMIs it possible to make a search or suiteQL that finds an item-fulfillment or sales-order that contains a specific sold item by its serial-number?
I am trying to make a search in item-fulfillment and joining on inventorydetail, but I cant make it work š
Eystein Bye
02/17/2021, 7:38 AMThis is what I am trying, but the debugger just hangs.
Copy code
search.create({
type:search.Type.ITEM_FULFILLMENT,
filters: [search.createFilter({
name: 'inventorynumber',
join: 'inventorydetail',
operator: <http://search.Operator.IS|search.Operator.IS>,
values: ['bcy32scy']
})],
columns:['entity'] // Any column from ITEM_FULFILLMENT
}).run()c
Chloƫ
02/17/2021, 9:14 PMI haven't done this through SuiteQL, however, I have accomplished this through a saved search. Create a transaction saved search, set the 'Type' to Sales Orders and Item Fulfillments, add 'Inventory Detail fields... Number' and set it to 'any of' and then select the serial number you're searching for.
e
Eystein Bye
02/18/2021, 10:54 AM@Chloƫ Could you help me with an example? I tried to change my operator to ANYOF, but my script debugger still just hangs when I run it
c
Chloƫ
02/18/2021, 10:37 PM@Eystein Bye Here is the criteria of a Transaction Saved Search that searches for a specific SN from item fulfillments
Chloƫ
02/18/2021, 10:37 PMmessage has been deleted