In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Passing a Dashboard Parameter to Widget and if blank return all
Just doing a simple Dashboard and I have a Company parameter that get's its value from PX.SM.Branch
Now I have the issue, when the value is a Branch then it works
How do I specify "Or the Company Parameter is empty or blank" because I tried a whole lot of ways with zero results.
"Branch" = [Company] OR [Company] = '' OR [Company] Is Null
I'm on around 2021R1 (this isn't pure Acumatica).
Any help appreciated
The idea is to have a dynamic list so don't really want to create a whole bunch of shared filters
So I found the reason why this didn't work.
When I created the Dashboard I created the Parameter as Required.
I then created the widgets with the filter.
Then I changed the Parameter to not be required
This caused the issue.
After changing the Parameter to not be required you need to edit the Widget again and just save it. Then the widget will work as expected!
It seems that the widget looks at the parameter when created to see if the parameter is required or not and saves that until the next edit. So if you change the Parameter then you need to edit and save each widget to get the new setting.