So,
As we all know, Netsuite's search don't support SQL statements (a real shame). Instead, you need to create a bunch on variables, fields, etc to to execute a simple search.
For years, I've been building a library to remove this, and I just updated it for SS2.0 ... see it at npm at https://www.npmjs.com/package/@darrenhillconsulting/jsuite
I'm taking on an impossible dream now ... attempting to mimic the SELECT * in SQL
Essentially, when you request 'customer' (or any other record for that matter), I do the following [LIST=1]
[*]create a temp record of the request recordType
[*]use the getFields() function to get all possible fields
[LIST]
[*]the problem is that it gives you EVERY field .. most of which are not valid search fields
[/LIST]
[*]I then filter out those fields against valid search fields
[*]I also allow any 'custentity' fields to go through
[*]I create searchColumns based on these names
[LIST]
[*]I do so creating 'formulas' so if Netsuite doesn't like the search column, it won't fail
[/LIST]
[*]I do some tidying up of the results
[/LIST] It works 'ok', but I'm sure it could be better,
This is a long way of asking if anyone else has ever tried to implement a similar feature/behaviour.
If we could do this, there's great potential I think.