My customer wants GI screens with “Between” on string/varchar fields. I don’t see a way to do this in a GI. Am I missing something?
Solved
GI Parameters for Greater Than/Less Than/Between on Account Code
Best answer by Fernando Amadoz
Use this GI reference.
I just created it and does filter as expected.
+2OOB, that filter option is available on DateTime and numeric controls with the native grid column properties.
It is not available in string values like AccountCD
You could try to build it with GI parameters. The users would then filter by parameters available in the header of the page, as opposed of filtering with the column filters.
I’ve tried to build it with header parameters, but when I use Greater Than/Less Than/Between on the conditional against string/varchar fields they do not work.
+2Use this GI reference.
I just created it and does filter as expected.
+2Use the GI from this thread as reference and expand it to include the AccountID as a parameter as well.
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.