https://netsuiteprofessionals.com logo
Join Slack
Powered by
Does anyone know how to reset the global search li...
# general
i
Does anyone know how to reset the global search list view? We are getting a weird error for a user that seems to have changed his view. "There is a divide by zero error in this search. It may be an error with a formula you have used. Please retry without the formula(s). If an error still occurs, please file with Customer Support. If it does not, please correct your formula. Typically that consists of taking the denominator and wrapping it in NULLIF(<denominator>,0)."
a
Can you give an example for what you are searching for? In general, if your results have many record types, it will show a generic view. But, if your search returns only a single record type, then it will can use the default view for that record type.
i
Its literally a single item in NS. So when you type in the global search and hit enter, this is the error that comes up
It's the only record with that name at all so it's something with the global search settings, but its user specific not role specific so it's something the user changed I feel like.
Do you know how to just default the global search view back to as if it was a new user account?
a
You can, but will need to do this by modifying the "Preferred Search Results" for that object type. I.e "Preferred Item Search Results" is the default one for items. You could customize that search, make it public, and then make it the Preferred Search Results globally or just for that role.
i
I'm not seeing that search come up when I look for it
a
try searching for any of your items in the global search (making sure that when the global search results come up, it says Global Search: Item Results. From there, click Customize.
i
Yea no such luck
and I even had him directly go to the search and check the my preferred search results check box on the results tab
the weird thing is its not role specific
theres only 2 people who are having this issue with this item and one is an admin and the other is a CSR type role
and I cant replicate it
Oh wait I lied, it is happening to another person with that role
but when I give myself that role I can't replicate it
a
let me see if I can replicate the problem on my account.
i
Thanks
a
Weird, I replied and then it didn't show up. I was able to replicate and fix the issue on my side
If you create a new item search. Reports --> New Search. Choose Item. Click Create Saved Search. Check the columns to make sure the offending field isn't present. On the results tab, click the My Preferred Search Results checkbox. Click save. Try to search agian and you shouldn't get the error. My guess is that a new item field was created with Show In List checked. This field likely has a formula so is being applied to many user's global searches (if they are using the default)
i
Thanks, I will give that a shot today. I appreciate the help.
👍 1
What did you do to replicate the issue? So we can try to avoid it happening again.
a
I created a saved search and added a formula field that resulted in a divide by zero error. I.e {price}/{price} and set an item base price = 0. I made this my preferred search results by checking the checkbox on the saved search. Then I created a separate saved search without that formula, set that as my preferred search results, and I no longer received the error.
i
Gotcha, thank you so much!
6 Views
Open in Slack
PreviousNext
Powered by