in SuiteQL is there a way to get the order that ch...
# suiteqlj
jen
12/20/2023, 3:58 PMin SuiteQL is there a way to get the order that child records appear on a parent record?
s
Simon
12/20/2023, 8:46 PMYes. Likely you are thinking about transaction. Use Transactionline
Simon
12/20/2023, 9:09 PMSELECT item, itemtype, custcol_weight
FROM transactionline
WHERE transactionline.transaction = transaction.id
j
jen
12/20/2023, 10:37 PMnot transaction
jen
12/20/2023, 10:37 PMcustom records
jen
12/20/2023, 10:37 PMcustom record as child on custom parent record
s
Simon
12/21/2023, 12:19 AMOK. Which custom parent record ?
j
jen
12/21/2023, 5:31 PMdoes it matter? It’s custom to our account, it’s a custom record type I created.
8 Views