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?
Answer
Is it possible to create a parameter on a free text field?
+4Best answer by BenjaminCrisman
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
+10Yes, you can use “Contains” which is equivalent of SQL LIKE operator for your purpose
Reza Aghaei CPA, M. Acc. & Acumatica Customization - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
+4
+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
+10You 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
+4You 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.
+4So 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
+4Thank you!
Jeff G.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.