0

I can get all item fulfillment ids but on multiple records using this query:

{
"q": "SELECT DISTINCT t.ID,t.TranID FROM NextTransactionLineLink AS ntll INNER JOIN Transaction AS t ON ( t.ID = ntll.NextDoc  ) WHERE t.type='ItemShip' AND  ( ntll.PreviousDoc = 7790 )"

}

Dario Perez
  • 31
  • 5
  • Fix whatever consumes the result to accept multiple records in the format SuiteQL returns them in. – Brian Aug 22 '23 at 14:17
  • What I need is a function like the “FOR XML PATH” in TSQL so I could get it natively from suiteql – Dario Perez Aug 23 '23 at 00:43

0 Answers0