can I use SuiteQL's BUILTIN.HIERARCHY with List/Record custom fields that have an hierarchy? If not, how can I fetch the full display path of a List/Record custom field using SuiteQL, including the full root ancestor parent?

AI generated answer (using internal Slack threads):

Based on the conversations, it appears that SuiteQL's BUILTIN.HIERARCHY function cannot be used with List/Record custom fields that have a hierarchy. However, you can use SuiteQL to fetch the full display path of a List/Record custom field. To get the full path name, you can use the

N/search

to get the name column. This was suggested in one of the conversations. However, the exact SuiteQL query to achieve this was not provided in the conversations. In another conversation, it was suggested that you can use SuiteQL to query for a list of all custom fields with the query

select * from customfield

. This might be a starting point for you to construct a query that fetches the full display path of a List/Record custom field. Remember to replace

customfield

with the actual name of your custom field. Also, you might need to join multiple tables in your query to get the full display path, depending on how your custom fields and their hierarchy are set up. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

by using joins