Using SuiteQL, is there a way to tell all custom r...
# suiteqlj
jen
03/12/2024, 4:52 PMUsing SuiteQL, is there a way to tell all custom records types that are Child Records of another custom record type? I can retrieve a list of custom fields on custom records where the TYPE of the field is the parent custom record type, but that won’t tell me if
RECORD IS PARENTjen
03/12/2024, 5:14 PMI think I can achieve this w/SS by doing a record.create then iterating through getSublists() looking for which ones start w/ ‘recmachcustrecord’
c
Clay Roper
03/12/2024, 5:15 PMBeat me to it 😄
Clay Roper
03/12/2024, 5:25 PM@jen Or you can load the custom record type itself and look at the
childrenj
jen
03/12/2024, 5:28 PMthere’s a
childrenjen
03/12/2024, 5:28 PMTIL
c
Clay Roper
03/12/2024, 5:28 PMMe too 😄
Clay Roper
03/12/2024, 5:28 PMpoke and prod
Clay Roper
03/12/2024, 5:29 PMSomething like this
j
jen
03/12/2024, 5:40 PMi can’t find a sublist with sublistId: ‘children’
jen
03/12/2024, 5:40 PMam I being dense
c
Clay Roper
03/12/2024, 5:45 PMYou're able to load the custom record using the custom record's numeric internal ID?
j
jen
03/12/2024, 5:45 PMyes
jen
03/12/2024, 5:46 PM Copy code
var ws = record.load({type: 'customrecord_applications', id: 50679});
// This seems to be null
ws.getSublist({sublistId: 'children'});c
Clay Roper
03/12/2024, 5:47 PMWhat I mean is: load a record of type "customrecordtype" with the internal ID that corresponds to the custom record type "customrecord_applications"
j
jen
03/12/2024, 5:48 PMohhh
jen
03/12/2024, 5:48 PMthis is what happens when I try to figure this out while in a teams meeting
c
Clay Roper
03/12/2024, 5:48 PMalso, there's a lot of types of records and records of types and internal IDs of things - the possibilities are endless
j
jen
03/12/2024, 5:49 PMboo yah
jen
03/12/2024, 5:49 PMit works
jen
03/12/2024, 5:49 PMTHANK YOU
c
Clay Roper
03/12/2024, 5:50 PMde nada! Glad it's of use
32 Views