Hey all, does anyone know of a way to get around the 1000 character limit on saved search results? I'm trying to find any item records where a certain field's value is > 2000 characters long, but I get no results because Netsuite truncates the field to 1000 characters. I have tried getting around this by adding in a formula field and getting the substring of the field from character 2000 onwards, but that doesn't work either.

I would try the Analytics - DataSet to see if it's also an issue in that context. If you know just a little bit of SuiteScript, the thing could be resolved in a function of probably under 10 lines. Another idea: custom field on the record that is a non-stored field, type integer, that has as its default value LENGTH({thereallylongfield}). Then search on that field. EDITED TO ADD: Ugh ... I don't think you can search on a non-stored field. Well, make it a stored field, set the value using MASS UPDATE or CSV Import (or scripting), and then you can search on it.

Thanks for those suggestions @zvictor, appreciate it. Yeah, I know I could do this with SuiteScript quite easily, but was hoping there'd be a native way from within the saved search (as I would just add this to the reminders portlet for the team, so they can review them quite easily). I've gone the SuiteScript route in the end and just dump the item records into a custom record.