Is there a way to query a list of sublist values a...
# suitescript
c
Is there a way to query a list of sublist values available? Example: When selecting a price level there are only 2-3 values based on which ones have a price entered. Ideally since the system already sourced the data we wouldn’t perform a second search to pull it.
Looks like I can call
getCurrentSublistField()
and then
field.getSelectOptions()
to get the values available without an additional query.
s
That may always work in the price level field, but will not always work across the board. It is limited to 500 values and also can return nothing if you have the double chevron in the UI (Home → Set Preferences → Maximum Entries in Dropdowns sets this and is user-specific 🙃 )
s
also, it may well be doing an additional query when you invoke that function - would have to look at its implementation to know for sure.