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

How to access a record sublist using N/Query module?

Assuming you mean transactions, sublist lines are a join on `transactionlines` (just like they are in the UI, the UI gives you the id and everything you need.  However, I'd probably recommend just learning/using SuiteQL over the `N/query` .

Hi <@U7XBU8Y3B>, thank you for your reply, Actually what I need is translations sublist on item records. It seems I can't access it using SuiteQL.

Do you know if there are certain sublists that are not accessible?

Thank you

There are definitely plenty of records/sublist not available to query, translation would not surprise me at all to be in that boat

Actually what I'm trying to achieve is to bypass the 1000 characters limitation we have when using N/search module. Any ideas?

Query actually has a lower limit, so it wouldnt help.  It truncates strings to be even shorter in my experience.

I'm pretty sure the strings are only truncated if you have complex search criteria, remove joins/formulas and the strings will not long be truncated

<https://netsuitehub.com/forums/topic/text-area-limit-reached-in-saved-search/>
```This is the exact feedback from our engineers:

"Unfortunately, due to the limitations imposed by underlying technology (Oracle) we are not able to display in certain cases Detailed Descriptions longer than 1300 bytes. These cases are rather rare and are caused by a combination of certain feature set in the customer account and criteria used in the search. Therefore, we recommend changing the search criteria to avoid the truncation happening. This limitation will be documented in the online help."```
