Does anyone know a way with SuiteQL to get child r...
# suiteqlj
jen
03/12/2025, 7:13 PMDoes anyone know a way with SuiteQL to get child records of a parent record (both custom) in the right ORDER (i.e. the order that they appear when in edit mode on the parent record in the UI)?
c
creece
03/12/2025, 7:43 PMI'd look at what it's ordering by in the UI and just order by that in the SQL
j
jen
03/12/2025, 7:45 PMI need it to be in the order it appears in edit mode, which is not by clicking a column header, it’s the line id order, but that’s not exposed to SuiteQL.
jen
03/12/2025, 7:46 PMas far as I can tell
c
creece
03/12/2025, 7:47 PMinternal ID isn't gonna work there?
creece
03/12/2025, 7:52 PMWhen I tested this, edit mode has them in the order I created them in which should be increasing internal IDs (should).
j
jen
03/12/2025, 7:56 PMit’s possible the internal ids could become unreliable if people change the parent record on a child
jen
03/12/2025, 7:57 PMor if you insert higher in the order
jen
03/12/2025, 7:57 PMafter saving the parent and reopening in edit mode
c
creece
03/12/2025, 8:05 PMWell if you want to do the line sequence # and its not exposed, you may have to add it as a custom field and populate it and then order by that custom field. I haven't run across it so just thinking out loud
j
jen
03/12/2025, 8:15 PMyeah this was more of a “is there a secret table I don’t know about” question.
17 Views