[abhishek]

Hi friends,

I am using a search operation via my code / SuiteTalk, however in case of advanced search when i get a joined result i get the internal id and not the field name, is there a way i can get the field name and not the internal id, is there a setting hidden somewhere where i can get internal id for some and the field name for others.

Please let me know / if you need more info,

thanks
This is a cached copy. Click here to see the original post.

[andrew.kefalas]

You can use the SQL function TO_CHAR to get the text of the result instead of the internal id.

eg:

var formulaColumn = new nlobjSearchColumn(‘formulatext’, null, “max”);

formulaColumn.setFormula(“to_char({item.id})”);

[abhishek]

Sorry for a late reply ,

Unfortunately it doesnt worked for me.

[Author]

Posts