Skip to main content
Answer

GI Parameters for Greater Than/Less Than/Between on Account Code

  • July 21, 2022
  • 5 replies
  • 182 views

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?

Best answer by Fernando Amadoz

@PSchirf61 

Use this GI reference.

I just created it and does filter as expected.

 

5 replies

Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

@PSchirf61 

OOB, 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.


  • Author
  • Freshman II
  • July 21, 2022

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.


Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

@PSchirf61 

Use this GI reference.

I just created it and does filter as expected.

 


  • Freshman II
  • January 9, 2024

@Fernando Amadoz Is it possible to use a selector for Account IDs? This GI doesn't currently have a selector for Account IDs. 


Fernando Amadoz
Jr Varsity I
Forum|alt.badge.img+2

@KumarDighe Certainly. That should be possible. You can filter GIs by any field that belongs to the DAC.

Use the GI from this thread as reference and expand it to include the AccountID as a parameter as well.