This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Has anyone managed to use `BUILTIN.HIERARCHY`?

`select builtin.hierarchy(parent, 'DISPLAY_JOINED') from department`

Did you manage to make this example work? I always get an error

I use <http://NetSuite2.com|NetSuite2.com> datasource if it will make any difference

Thanks Selcuk. I'm trying on a custom record created from a custom segment. I get an unexpected error when I try your example in N/query

if the script id of the parent field is different, it would be changed. otherwise it would be most probably that NetSuite does not support it for custom records

Nah `parent` is correct, and I get an error with the department table as well through SuiteScript

I tried with N/query and for me also it threw unexpected error