Skip to main content

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?

@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.


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.


@PSchirf61 

Use this GI reference.

I just created it and does filter as expected.

 


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


@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.

 


Reply