By using this website, you agree to our Terms of Use (click here)
Hi Everyone,
I added my first Parameter to a Generic Inquiry in Acumatica. I noticed that I have to add the Parameter to the Conditions tab if I want it to filter anything which makes sense.
But now I'm wondering if it's possible to allow someone to leave the parameter empty. In other words, if it is left empty, then the Generic Inquiry will return all rows. But if the user fills in a value, then the Generic Inquiry will be filtered with that value.
Does anyone know if this is possible?
Hi Scooter,
Try the trick in the screenshot below.
Basically, this allows for two conditions: Either the parameter has a value and gets used to filter the data or the parameter is empty so no filter is applied.
The key is the Or value in the Operator column. But be sure to put in the brackets in the two Brackets columns in case you have other conditions. You don't want your Or value to mess up any other conditions that you have in place.
I didn't think of that, but it makes complete sense now that you point it out!
And thanks for the screenshot, that makes it even easier to follow.
Online Members
