I’m looking to create an easy way for our sales people to filter sales order based on info in the order description.
Since that is a free text field, is it possible to create a parameter on a GI for it?
Best answer by BenjaminCrisman
View originalI’m looking to create an easy way for our sales people to filter sales order based on info in the order description.
Since that is a free text field, is it possible to create a parameter on a GI for it?
Best answer by BenjaminCrisman
View originalYes, you can use “Contains” which is equivalent of SQL LIKE operator for your purpose
Thank you! Can I make it not required? Although the required checkbox is unchecked, it doesn’t show any results unless I enter something in the parameter box
You can remove the required checkbox from the “Parameter” then in the “Filter” do as follow:
( YourPM is Empty OR
DAC.Field Contains YourPM )
You can have more filter conditions outside the opening and closing brackets as shown above if you need.
It will work
You can remove the required checkbox from the “Parameter” then in the “Filter” do as follow:
( YourPM is Empty OR
DAC.Field Contains YourPM )
You can have more filter conditions outside the opening and closing brackets as shown above if you need.
It will work
Is empty will not display anything since they are not empty.
So in my example the parameter and condition looked like this:
If yours looks like this it should work, if not, paste a screenshot so we can see it
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.