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 originalIs it possible to create a parameter on a free text field?
Userlevel 6
+4
Userlevel 7
+8
Yes, you can use “Contains” which is equivalent of SQL LIKE operator for your purpose
Userlevel 7
+4
Userlevel 6
+4
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
Userlevel 7
+8
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
Userlevel 6
+4
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.
Userlevel 7
+4
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
Userlevel 6
+4
Thank you!
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.