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 can I run a search for Tasks that have more than 6 words title?

I'd use suiteql with one of the Oracle `REGEXP_` functions in the `where` clause to look for things with more than &gt;5 occurrences of whitespace

`var resultset = query.runSuiteQL({ query: "select * from tasks where length(regexp_replace(name,'\S',''))&gt;5" });`

<@U02053YFW1H> Thanks, but it shows all of them. I think there is a problem in where clause.

Damn, the query works via ODBC :disappointed:

You can try using `REGEXP_LIKE({title}, '(\w+\s+){4,}\w+.*')`
That would probably treat strings containing numbers as words, too, but you can modify if necessary

Another option is `REGEXP_COUNT({memo}, '\s') + 1` for get the number of whitespace characters. Works well in a saved search