Worked on a little script to help find unique valu...
# suitescript
s
Worked on a little script to help find unique values for a field across a record type. Shared it on the other channel. Probably more appropriate here.
b
assuming you are comparing text, you may want to make it case sensitive
as far as netsuite search is concerned, A and a are the same
s
@battk what section is not-case sensitive in your opinion? the search?
b
yes
s
Any suggestions on how to do that? I see some stuff online using INSTR. In our current case, however, we don’t necessarily care for case sensitivity.
b
from memory, when i had to do this, I just got all the search results and made sure that the field value matches the search result value before declaring it unique
s
Got it! Thanks a ton.